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