For the sake of curiosity, is anyone (as in any human) using RIGHT JOIN? Personally I never had a need for a RIGHT JOIN, not because of theoretical or design considerations, but it just never came into my flow of thought when writing SQL...
I guess some automated SQL query generators could use it though, because they do not have a "flow of thought". On Tue, Mar 21, 2017 at 9:50 PM, Darren Duncan <dar...@darrenduncan.net> wrote: > What benefit does a RIGHT JOIN give over a LEFT JOIN? What queries are > more natural to write using the first rather than the second? > > While I can understand arguments based on simple mirror parity, eg we have > < so we should have > too, lots of other operations don't have mirror > syntax either. > > -- Darren Duncan > > On 2017-03-21 8:42 AM, Daniel Kamil Kozar wrote: > >> Seeing how SQLite was created in 2000, it seems like nobody really >> needed this feature for the last 17 years enough in order to actually >> implement it. >> >> Last I heard, patches are welcome on this mailing list. Don't keep us >> waiting. >> >> Kind regards, >> Daniel >> >> On 20 March 2017 at 21:09, PICCORO McKAY Lenz <mckaygerh...@gmail.com> >> wrote: >> >>> i got this >>> >>> Query Error: RIGHT and FULL OUTER JOINs are not currently supported >>> Unable to execute statement >>> >>> still today in 21 ts century? >>> >>> Lenz McKAY Gerardo (PICCORO) >>> http://qgqlochekone.blogspot.com >>> >> > _______________________________________________ > 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