On 6 Dec 2017, at 9:36am, Jean-Luc Hainaut <jean-luc.hain...@unamur.be> wrote:
> Actually, the left outer join is sufficient to execute all the outer join > operators: > > - right outer join: just swap the "from" arguments > > - full outer joins: union of left and right outer joins I never realised that. It’s clever. And it’s also a cheap way to implement FULL JOINs. Not optimized, but it simple, and changes "can’t do" to "can do". Thanks. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users