Bart Smissaert wrote:
> I did try left joins, but no data returned.

All filters for outer-joined rows must be specified in the JOIN itself;
in the WHERE clause, NULL values would make the comparison fail.


Regards,
Clemens
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to