Hi 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? _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
