Came across this when using SQLite on a development project.
IO confess I didnt know but this does make SQLite problematic if right join is needed.
Guess for the moment i need to use a left with the tables reversed
Well right joins are not very commonly used and actually can be done now much more clean with sub table queries.
I agree not often use but not about sub tables. It totally depends on the structure of your DB.
I think the only time i use them is to find what is contained in the right table which is not in the left i.e.
RIGHT JOIN WHERE fieldname = Null
As I posted, easy to get around it but users may want to know this before using SQLite platform
I found it as i was writing a primer of SQL joins, sub tables and multi references, kind if hard to skirt the right join being lacking!
1 Like