On 5 Oct 2009, at 1:02pm, Tim Lind wrote: > I have a query that is using a left join, with a where clause, and the > results I expect are not returned because the one table doesn't have a > related record. > If I put the constraint in the on clause of the query instead, the > expected results are returned with the null record of the related > table. > > Is this standard behaviour of SQL or specific to SQLite?
Standard SQL, and things you do need to consider when deciding the phrasing of your SELECT command. Which kind of JOIN you use makes a difference. Which of the tables you use in your WHERE clause makes a difference. Check out how a RIGHT JOIN works, and watch your clauses. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
