How to exclude rows that don’t join with another table?

by

alt text

SELECT <select_list> 
FROM Table_A A
LEFT JOIN Table_B B
ON A.Key = B.Key
WHERE B.Key IS NULL

Full image of join
alt text

From aticle : http://www.codeproject.com/KB/database/Visual_SQL_Joins.aspx

More Related Contents:

  1. What is the result of following SQL Query?
  2. What is the difference between “INNER JOIN” and “OUTER JOIN”?
  3. Explicit vs implicit SQL joins
  4. Join vs. sub-query
  5. Can I use CASE statement in a JOIN condition?
  6. What is the difference between Left, Right, Outer and Inner Joins? [duplicate]
  7. SQL join: selecting the last records in a one-to-many relationship
  8. Subqueries vs joins
  9. Difference between left join and right join in SQL Server [duplicate]
  10. What is the difference between JOIN and UNION?
  11. Filter Table Before Applying Left Join
  12. Left Outer Join Not Working?
  13. SQL Join Differences
  14. Difference between natural join and inner join
  15. Are “from Table1 left join Table2” and “from Table2 right join Table1” interchangeable?
  16. Inner Join vs Natural Join vs USING clause: are there any advantages?
  17. Natural join in SQL Server
  18. Including null values in an Apache Spark Join
  19. Is a JOIN faster than a WHERE?
  20. Select only rows by join tables max value
  21. Is it true that using INNER JOIN after any OUTER JOIN will essentially invalidate the effects of OUTER JOIN?
  22. What is semi-join in database?
  23. MySQL: GROUP_CONCAT with LEFT JOIN
  24. Merge two rows in SQL
  25. Joining multiple tables in SQL
  26. What is the difference between a LATERAL JOIN and a subquery in PostgreSQL?
  27. sql sum data from multiple tables
  28. SQL server join tables and pivot
  29. IN vs. JOIN with large rowsets
  30. SQL join on multiple columns in same tables

Leave a Comment