Filter Table Before Applying Left Join

by

You need to move the WHERE filter to the JOIN condition:

SELECT c.Customer, c.State, e.Entry
FROM Customer c
LEFT JOIN Entry e
   ON c.Customer=e.Customer
   AND e.Category='D'

See SQL Fiddle with Demo

More Related Contents:

  1. SQL JOIN – WHERE clause vs. ON clause
  2. In SQL / MySQL, what is the difference between “ON” and “WHERE” in a join statement?
  3. Is a JOIN faster than a WHERE?
  4. INNER JOIN ON vs WHERE clause
  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. Difference between JOIN and INNER JOIN
  8. Left Join With Where Clause
  9. Difference between Oracle’s plus (+) notation and ansi JOIN notation?
  10. SQL to LINQ with multiple join, count and left join
  11. What is the difference between HAVING and WHERE in SQL?
  12. Oracle “(+)” Operator
  13. JOIN two SELECT statement results
  14. FULL OUTER JOIN with SQLite
  15. Is there something wrong with joins that don’t use the JOIN keyword in SQL or MySQL?
  16. Mixing implicit and explicit JOINs
  17. SQL server ignore case in a where expression
  18. Record returned from function has columns concatenated
  19. Explain JOIN vs. LEFT JOIN and WHERE condition performance suggestion in more detail
  20. Difference between RIGHT & LEFT JOIN vs RIGHT & LEFT OUTER JOIN in SQL [duplicate]
  21. PostgreSQL JOIN with array type with array elements order, how to implement?
  22. How to exclude rows that don’t join with another table?
  23. Left Join without duplicate rows from left table
  24. Oracle date “Between” Query
  25. INNER JOIN vs multiple table names in “FROM” [duplicate]
  26. Is NATURAL (JOIN) considered harmful in production environment?
  27. Re-Writing “Fuzzy Join” Functions from R to SQL
  28. SQL select join: is it possible to prefix all columns as ‘prefix.*’?
  29. sql query joins multiple tables – too slow (8 tables)
  30. Procedurally transform subquery into join

Leave a Comment