On 6 Dec 2017, at 9:36am, Jean-Luc Hainaut <[email protected]> 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 [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
