Lines Matching refs:t1
25 CREATE TABLE t1(a,b,c);
26 INSERT INTO t1 VALUES(1,2,3);
27 INSERT INTO t1 VALUES(2,3,4);
28 INSERT INTO t1 VALUES(3,4,5);
29 SELECT * FROM t1;
44 SELECT * FROM t1 NATURAL JOIN t2;
46 } {t1.a 1 t1.b 2 t1.c 3 t2.d 4 t1.a 2 t1.b 3 t1.c 4 t2.d 5}
49 SELECT * FROM t2 NATURAL JOIN t1;
51 } {t2.b 2 t2.c 3 t2.d 4 t1.a 1 t2.b 3 t2.c 4 t2.d 5 t1.a 2}
54 SELECT * FROM t1 INNER JOIN t2 USING(b,c);
56 } {t1.a 1 t1.b 2 t1.c 3 t2.d 4 t1.a 2 t1.b 3 t1.c 4 t2.d 5}
59 SELECT * FROM t1 INNER JOIN t2 USING(b);
61 } {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}
64 SELECT * FROM t1 INNER JOIN t2 USING(c);
66 } {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}
69 SELECT * FROM t1 INNER JOIN t2 USING(c,b);
71 } {t1.a 1 t1.b 2 t1.c 3 t2.d 4 t1.a 2 t1.b 3 t1.c 4 t2.d 5}
75 SELECT * FROM t1 NATURAL CROSS JOIN t2;
80 SELECT * FROM t1 CROSS JOIN t2 USING(b,c);
85 SELECT * FROM t1 NATURAL INNER JOIN t2;
90 SELECT * FROM t1 INNER JOIN t2 USING(b,c);
95 SELECT * FROM t1 natural inner join t2;
100 SELECT * FROM t1 NATURAL JOIN
103 } {t1.a 1 t1.b 2 t1.c 3 t3.d 4 t3.e 5}
107 NATURAL JOIN t1
109 } {tx.c 3 tx.d 4 tx.e 5 t1.a 1 t1.b 2}
122 SELECT * FROM t1 natural join t2 natural join t3;
127 SELECT * FROM t1 natural join t2 natural join t3;
129 } {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}
141 SELECT * FROM t1 natural join t2 natural join t4;
146 SELECT * FROM t1 natural join t2 natural join t4;
148 } {t1.a 1 t1.b 2 t1.c 3 t2.d 4 t4.e 5 t4.f 6}
151 SELECT * FROM t1 natural join t2 natural join t3 WHERE t1.a=1
157 SELECT * FROM t1 NATURAL LEFT JOIN t2;
162 SELECT * FROM t2 NATURAL LEFT OUTER JOIN t1;
167 SELECT * FROM t1 NATURAL RIGHT OUTER JOIN t2;
172 SELECT * FROM t1 LEFT JOIN t2 ON t1.a=t2.d
177 SELECT * FROM t1 LEFT JOIN t2 ON t1.a=t2.d WHERE t1.a>1
182 SELECT * FROM t1 LEFT JOIN t2 ON t1.a=t2.d WHERE t2.b IS NULL OR t2.b>1
188 SELECT * FROM t1 NATURAL JOIN t2 ON t1.a=t2.b;
193 SELECT * FROM t1 NATURAL JOIN t2 USING(b);
198 SELECT * FROM t1 JOIN t2 ON t1.a=t2.b USING(b);
203 SELECT * FROM t1 JOIN t2 USING(a);
208 SELECT * FROM t1 USING(a);
213 SELECT * FROM t1 JOIN t2 ON t3.a=t2.b;
218 SELECT * FROM t1 INNER OUTER JOIN t2;
223 SELECT * FROM t1 LEFT BOGUS JOIN t2;