Just in case you didn't know, SQLite doesn't support right joins?

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

image1528×141 6.38 KB