left join turns into inner join

by

It’s because of your WHERE clause.

Whenever you specify a value from the right side of a left join in a WHERE clause (which is NOT NULL), you necessarily eliminate all of the NULL values and it essentially becomes an INNER JOIN.

If you write, AND (c.foobar="somethingelse" OR c.foobar IS NULL) that will solve the problem.

You can also move the c.foobar portion into your join predicate, and that too will solve the issue.

More Related Contents:

  1. What is wrong with this DB Diagram? [closed]
  2. I’m getting ‘Column name is invalid in the select list’ error when i execute the query
  3. Efficiently convert rows to columns in sql server
  4. You can’t specify target table for update in FROM clause
  5. Not equal != operator on NULL
  6. How to randomly select rows in SQL?
  7. How can I select the first day of a month in SQL?
  8. How to return result of a SELECT inside a function in PostgreSQL?
  9. What are valid table names in SQLite?
  10. How do you create a temporary table in an Oracle database?
  11. Reset auto increment counter in postgres
  12. JOIN two SELECT statement results
  13. Is it possible to specify condition in Count()?
  14. What’s the difference between VARCHAR and CHAR?
  15. get JOIN table as array of results with PostgreSQL/NodeJS
  16. How can I send email from PostgreSQL trigger?
  17. How to cast variables in T-SQL for bulk insert?
  18. “select * from table” vs “select colA, colB, etc. from table” interesting behaviour in SQL Server 2005
  19. Pivot data in T-SQL
  20. Postgres sql insert query syntax error from phpPgAdmin
  21. Extracting hours from a DateTime (SQL Server 2005)
  22. SQL ORDER BY date problem
  23. Retrieve inserted row ID in SQL
  24. Sql Server trigger insert values from new row into another table
  25. UNION ALL vs OR condition in sql server query
  26. How to Execute SQL Query without Displaying results
  27. How to insert a string which contains an “&”
  28. Subtracting Dates in Oracle – Number or Interval Datatype?
  29. PostgreSQL – dynamic value as table name [duplicate]
  30. Why are aggregate functions not allowed in where clause

Leave a Comment