-- original: join2.test -- credit: http://www.sqlite.org/src/tree?ci=trunk&name=test CREATE TABLE t1(a,b); INSERT INTO t1 VALUES(1,11); INSERT INTO t1 VALUES(2,22); INSERT INTO t1 VALUES(3,33); SELECT * FROM t1 ;CREATE TABLE t2(b,c); INSERT INTO t2 VALUES(11,111); INSERT INTO t2 VALUES(33,333); INSERT INTO t2 VALUES(44,444); SELECT * FROM t2 ;CREATE TABLE t3(c,d); INSERT INTO t3 VALUES(111,1111); INSERT INTO t3 VALUES(444,4444); INSERT INTO t3 VALUES(555,5555); SELECT * FROM t3 ;SELECT * FROM t1 NATURAL JOIN t2 NATURAL JOIN t3 ;SELECT * FROM t1 NATURAL JOIN t2 NATURAL LEFT OUTER JOIN t3 ;SELECT * FROM t1 NATURAL LEFT OUTER JOIN t2 NATURAL JOIN t3 ;SELECT * FROM t1 NATURAL LEFT OUTER JOIN (t2 NATURAL JOIN t3);