Ok, what should the query be? RBS
On Sun, 22 Sep 2019, 15:42 Clemens Ladisch, <clem...@ladisch.de> wrote: > 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 > _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
