On Wed, Mar 22, 2017 at 9:30 AM, R Smith <rsm...@rsweb.co.za> wrote: > > On 2017/03/22 9:53 AM, Eric Grange wrote: > >> 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". >> > > I had a need of it the other day (something that can easily be overcome > with a CTE or subquery, but still may have made the sql read more natural): >
I've also needed it for reasons I can't remember, but I know I've used the functionality. RIGHT JOIN is a pretty limited use case, but handy when needed. I think this OP came from another DBMS software, such as MS, that does support RIGHT JOIN. (At least from what memory serves when I took my MS courses back when MSSQL2K was just coming out) _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
