Lines Matching full:t2
32 CREATE TABLE t2(b,c,d);
33 INSERT INTO t2 VALUES(1,2,3);
34 INSERT INTO t2 VALUES(2,3,4);
35 INSERT INTO t2 VALUES(3,4,5);
36 SELECT * FROM t2;
42 SELECT * FROM t1 NATURAL JOIN t2;
44 } {t1.a 1 t1.b 2 t1.c 3 t2.d 4 t1.a 2 t1.b 3 t1.c 4 t2.d 5}
47 SELECT * FROM t2 NATURAL JOIN t1;
49 } {t2.b 2 t2.c 3 t2.d 4 t1.a 1 t2.b 3 t2.c 4 t2.d 5 t1.a 2}
52 SELECT * FROM t1 INNER JOIN t2 USING(b,c);
54 } {t1.a 1 t1.b 2 t1.c 3 t2.d 4 t1.a 2 t1.b 3 t1.c 4 t2.d 5}
57 SELECT * FROM t1 INNER JOIN t2 USING(b);
59 } {t1.a 1 t1.b 2 t1.c 3 t2.c 3 t2.d 4 t1.a 2 t1.b 3 t1.c 4 t2.c 4 t2.d 5}
62 SELECT * FROM t1 INNER JOIN t2 USING(c);
64 } {t1.a 1 t1.b 2 t1.c 3 t2.b 2 t2.d 4 t1.a 2 t1.b 3 t1.c 4 t2.b 3 t2.d 5}
67 SELECT * FROM t1 INNER JOIN t2 USING(c,b);
69 } {t1.a 1 t1.b 2 t1.c 3 t2.d 4 t1.a 2 t1.b 3 t1.c 4 t2.d 5}
73 SELECT * FROM t1 NATURAL CROSS JOIN t2;
78 SELECT * FROM t1 CROSS JOIN t2 USING(b,c);
83 SELECT * FROM t1 NATURAL INNER JOIN t2;
88 SELECT * FROM t1 INNER JOIN t2 USING(b,c);
93 SELECT * FROM t1 natural inner join t2;
99 (SELECT b as 'c', c as 'd', d as 'e' FROM t2) as t3
104 SELECT * FROM (SELECT b as 'c', c as 'd', d as 'e' FROM t2) as 'tx'
120 SELECT * FROM t1 natural join t2 natural join t3;
125 SELECT * FROM t1 natural join t2 natural join t3;
127 } {t1.a 1 t1.b 2 t1.c 3 t2.d 4 t3.e 5 t1.a 2 t1.b 3 t1.c 4 t2.d 5 t3.e 6}
139 SELECT * FROM t1 natural join t2 natural join t4;
144 SELECT * FROM t1 natural join t2 natural join t4;
146 } {t1.a 1 t1.b 2 t1.c 3 t2.d 4 t4.e 5 t4.f 6}
149 SELECT * FROM t1 natural join t2 natural join t3 WHERE t1.a=1
155 SELECT * FROM t1 NATURAL LEFT JOIN t2;
160 SELECT * FROM t2 NATURAL LEFT OUTER JOIN t1;
165 SELECT * FROM t1 NATURAL RIGHT OUTER JOIN t2;
170 SELECT * FROM t1 LEFT JOIN t2 ON t1.a=t2.d
175 SELECT * FROM t1 LEFT JOIN t2 ON t1.a=t2.d WHERE t1.a>1
180 SELECT * FROM t1 LEFT JOIN t2 ON t1.a=t2.d WHERE t2.b IS NULL OR t2.b>1
186 SELECT * FROM t1 NATURAL JOIN t2 ON t1.a=t2.b;
191 SELECT * FROM t1 NATURAL JOIN t2 USING(b);
196 SELECT * FROM t1 JOIN t2 ON t1.a=t2.b USING(b);
201 SELECT * FROM t1 JOIN t2 USING(a);
211 SELECT * FROM t1 JOIN t2 ON t3.a=t2.b;
216 SELECT * FROM t1 INNER OUTER JOIN t2;
221 SELECT * FROM t1 LEFT BOGUS JOIN t2;