the word OUTER in LEFT OUTER JOIN, RIGHT OUTER JOIN and FULL OUTER JOIN does not change the semantics of the JOIN

[juandent]

Except that FULL OUTER JOIN and RIGHT OUTER JOIN are not supported directly by SQLite.

So LEFT OUTER JOIN is equivalent to LEFT JOIN
RIGHT OUTER JOIN to RIGHT JOIN
FULL OUTER JOIN to FULL JOIN

This was taken from page 136 of "A Guide to the SQL Standard" fourth edition by C.J. Date with Hugh Darwen. Addison Wesley 1997.

[data-man]

Except that FULL OUTER JOIN and RIGHT OUTER JOIN are not supported directly by SQLite.

sqlite/sqlite@94e615a 🎉

[juandent]

But both outer joins can be implemented See the guide of sqlite_orm Juan Dent

…

Sent from my iPhone

On 14 Apr 2022, at 9:43 AM, Dmitry Atamanov ***@***.***> wrote:  Except that FULL OUTER JOIN and RIGHT OUTER JOIN are not supported directly by SQLite. ***@***.*** 🎉 — Reply to this email directly, view it on GitHub, or unsubscribe. You are receiving this because you authored the thread.