Re: [sqlite] Difference between all the joins

ts.com> wrote: > >> >> >> -Original Message- >> From: sqlite-users-boun...@sqlite.org >> [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Andrey Fedorov >> Sent: Tuesday, April 21, 2009 1:27 PM >> To: sqlite-users@sqlite.org >>

Re: [sqlite] Difference between all the joins

g > Subject: [sqlite] Difference between all the joins > > Hi all, > According to the join-op syntax [1], SQLite has 13 distinct join > statements: > > , > JOIN > LEFT JOIN > OUTER JOIN > LEFT OUTER JOIN > INNER JOIN > CROSS JOIN > NATURAL JOIN > NATURAL

Re: [sqlite] Difference between all the joins

-Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Andrey Fedorov Sent: Tuesday, April 21, 2009 1:27 PM To: sqlite-users@sqlite.org Subject: [sqlite] Difference between all the joins Hi all, According to the join-op syntax [1

[sqlite] Difference between all the joins

Hi all, According to the join-op syntax [1], SQLite has 13 distinct join statements: , JOIN LEFT JOIN OUTER JOIN LEFT OUTER JOIN INNER JOIN CROSS JOIN NATURAL JOIN NATURAL LEFT JOIN NATURAL OUTER JOIN NATURAL LEFT OUTER JOIN NATURAL INNER JOIN NATURAL CROSS JOIN Are they all unique? Which are equ