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

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

Related Contents:

  1. What is the difference between “INNER JOIN” and “OUTER JOIN”?
  2. How can I do a FULL OUTER JOIN in MySQL?
  3. INNER JOIN ON vs WHERE clause
  4. Explicit vs implicit SQL joins
  5. SQL update from one Table to another based on a ID match
  6. SQL JOIN: is there a difference between USING, ON or WHERE?
  7. Can I use CASE statement in a JOIN condition?
  8. What is the difference between Left, Right, Outer and Inner Joins? [duplicate]
  9. SQL join: selecting the last records in a one-to-many relationship
  10. Why isn’t SQL ANSI-92 standard better adopted over ANSI-89?
  11. Subqueries vs joins
  12. SQL to LINQ with multiple join, count and left join
  13. SQL left join vs multiple tables on FROM line?
  14. SQL Inner-join with 3 tables?
  15. Difference between Oracle’s plus (+) notation and ansi JOIN notation?
  16. Difference between left join and right join in SQL Server [duplicate]
  17. What is the difference between JOIN and UNION?
  18. Multiple INNER JOIN SQL ACCESS
  19. Filter Table Before Applying Left Join
  20. Left Outer Join Not Working?
  21. JOIN two SELECT statement results
  22. SQL Joins Vs SQL Subqueries (Performance)?
  23. FULL OUTER JOIN with SQLite
  24. SQLite – How do you join tables from different databases?
  25. Is there something wrong with joins that don’t use the JOIN keyword in SQL or MySQL?
  26. Difference between natural join and inner join
  27. Mixing implicit and explicit JOINs
  28. Natural join in SQL Server
  29. Why does this SQL code give error 1066 (Not unique table/alias: ‘user’)?
  30. Venn Diagram for Natural Join
  31. Are “from Table1 left join Table2” and “from Table2 right join Table1” interchangeable?
  32. What is the difference between a LATERAL JOIN and a subquery in PostgreSQL?
  33. Call a set-returning function with an array argument multiple times
  34. MySQL – Selecting data from multiple tables all with same structure but different data
  35. Record returned from function has columns concatenated
  36. In SQL / MySQL, what is the difference between “ON” and “WHERE” in a join statement?
  37. Is a JOIN faster than a WHERE?
  38. Is it true that using INNER JOIN after any OUTER JOIN will essentially invalidate the effects of OUTER JOIN?
  39. Explain JOIN vs. LEFT JOIN and WHERE condition performance suggestion in more detail
  40. SQL query: Simulating an “AND” over several rows instead of sub-querying
  41. ORA – 00933 confusion with inner join and “as”
  42. SQL SELECT from multiple tables
  43. Merge two rows in SQL
  44. SQL select join: is it possible to prefix all columns as ‘prefix.*’?
  45. PostgreSQL JOIN with array type with array elements order, how to implement?
  46. MySQL: GROUP_CONCAT with LEFT JOIN
  47. MySQL: “The SELECT would examine more than MAX_JOIN_SIZE rows”
  48. sql query joins multiple tables – too slow (8 tables)
  49. Difference between filtering queries in JOIN and WHERE?
  50. IN vs. JOIN with large rowsets

Leave a Comment