SQL join on multiple columns in same tables

by

You need to replace the second ON with AND, like this:

ON a.userid = b.sourceid AND a.listid = b.destinationid;

More Related Contents:

  1. What is the result of following SQL Query?
  2. How to display data in JOIN, and return null value? [closed]
  3. How can I do a FULL OUTER JOIN in MySQL?
  4. Join vs. sub-query
  5. SQL JOIN – WHERE clause vs. ON clause
  6. Can I use CASE statement in a JOIN condition?
  7. What is the difference between Left, Right, Outer and Inner Joins? [duplicate]
  8. Why isn’t SQL ANSI-92 standard better adopted over ANSI-89?
  9. Subqueries vs joins
  10. SQL to LINQ with multiple join, count and left join
  11. Difference between left join and right join in SQL Server [duplicate]
  12. Multiple INNER JOIN SQL ACCESS
  13. Oracle “(+)” Operator
  14. JOIN two SELECT statement results
  15. SQL Join Differences
  16. Implement paging (skip / take) functionality with this query
  17. Difference between natural join and inner join
  18. Is there something wrong with joins that don’t use the JOIN keyword in SQL or MySQL?
  19. Mixing implicit and explicit JOINs
  20. Why does this SQL code give error 1066 (Not unique table/alias: ‘user’)?
  21. Is a JOIN faster than a WHERE?
  22. Is it true that using INNER JOIN after any OUTER JOIN will essentially invalidate the effects of OUTER JOIN?
  23. Difference between RIGHT & LEFT JOIN vs RIGHT & LEFT OUTER JOIN in SQL [duplicate]
  24. Merge two rows in SQL
  25. How to exclude rows that don’t join with another table?
  26. Left Join without duplicate rows from left table
  27. Is NATURAL (JOIN) considered harmful in production environment?
  28. SQL select join: is it possible to prefix all columns as ‘prefix.*’?
  29. Removing duplicate rows (based on values from multiple columns) from SQL table
  30. sql query joins multiple tables – too slow (8 tables)

Leave a Comment