Lines Matching refs:t2

23     CREATE TABLE t2(c INT, d INT);
24     INSERT INTO t2 VALUES(3,33),(4,44),(5,55);
25     CREATE INDEX t2c ON t2(c);
32     CREATE TABLE t2(c INT, d INT);
33     INSERT INTO t2 VALUES(3,33),(4,44),(5,55);
34     CREATE INDEX t2cd ON t2(c,d);
41     CREATE TABLE t2(c INT, d INT PRIMARY KEY) WITHOUT ROWID;
42     INSERT INTO t2 VALUES(3,33),(4,44),(5,55);
43     CREATE INDEX t2c ON t2(c);
49     CREATE TABLE t2(c INTEGER PRIMARY KEY, d INT);
50     INSERT INTO t2 VALUES(3,33),(4,44),(5,55);
56     CREATE TABLE t2(c INT PRIMARY KEY, d INT) WITHOUT ROWID;
57     INSERT INTO t2 VALUES(3,33),(4,44),(5,55);
63     CREATE VIEW t2(c,d) AS VALUES(3,33),(4,44),(5,55);
68     CREATE TABLE t2(c INTEGER PRIMARY KEY, d INT);
69     INSERT INTO t2 VALUES(3,33),(4,44),(5,55);
75     CREATE TABLE t2(c INT, d INT);
76     INSERT INTO t2 VALUES(3,33),(4,44),(5,55);
84     CREATE VIEW t2(c,d) AS SELECT c, d FROM t2a NATURAL JOIN t2b;
95     CREATE VIEW t2(c,d) AS SELECT c, d FROM t2a NATURAL JOIN t2b;
108     SELECT b, d FROM t1 FULL OUTER JOIN t2 ON b=c ORDER BY +b;
118     SELECT a, c FROM t1 FULL OUTER JOIN t2 ON b=c ORDER BY +b;
127     SELECT * FROM t1 FULL OUTER JOIN t2 ON b=c ORDER BY +b;
135     SELECT t1.*, t2.* FROM t2 FULL OUTER JOIN t1 ON b=c ORDER BY +b;
143     SELECT t1.*, t2.* FROM t2 FULL OUTER JOIN t1 ON b=c
151     SELECT t1.*, t2.* FROM t2 FULL OUTER JOIN t1 ON b=c
160     SELECT t1.*, t2.* FROM t2 FULL OUTER JOIN t1 ON b=c
170     SELECT t1.*, t2.* FROM t2 FULL OUTER JOIN t1 ON b=c AND b>3 AND c>4
181     SELECT t1.*, t2.* FROM t2 FULL OUTER JOIN t1 ON b=c AND b>3 WHERE c>4
187     SELECT t1.*, t2.* FROM t2 FULL OUTER JOIN t1 ON b=c WHERE b>3 AND c>4
192     SELECT t1.*, t2.* FROM t2 FULL OUTER JOIN t1 ON b=c WHERE b>3 OR c>4
199     SELECT t1.*, t2.* FROM t2 FULL OUTER JOIN t1 ON b=c AND (b>3 OR c>4)
209     SELECT * FROM t1 RIGHT OUTER JOIN t2 ON b=c ORDER BY +b;
216     SELECT t1.*, t2.* FROM t2 LEFT OUTER JOIN t1 ON b=c ORDER BY +b;
223     SELECT * FROM dual JOIN t1 ON true RIGHT OUTER JOIN t2 ON b=c ORDER BY +b;
230     SELECT t1.*, t2.* 
231       FROM t2 LEFT JOIN (dual JOIN t1 ON true) ON b=c ORDER BY +b;
238     SELECT * FROM dual CROSS JOIN t1 RIGHT OUTER JOIN t2 ON b=c ORDER BY +b;
245     SELECT dual.*, t1.*, t2.*
246       FROM t1 CROSS JOIN dual RIGHT OUTER JOIN t2 ON b=c ORDER BY +b;
253     SELECT * FROM t1 LEFT OUTER JOIN t2 ON b=c ORDER BY +b;
260     SELECT * FROM t1 FULL OUTER JOIN t2 ON b=c AND a=1 ORDER BY +b;
268     SELECT t1.*, t2.* FROM t2 FULL OUTER JOIN t1 ON b=c AND a=1 ORDER BY +b;
278     SELECT * FROM t1 FULL OUTER JOIN t2 ON b=c WHERE a=1 ORDER BY +b;
286     SELECT t1.*, t2.* FROM t2 FULL OUTER JOIN t1 ON b=c WHERE a=1 ORDER BY +b;
295     SELECT * FROM t1 FULL OUTER JOIN t2 ON b=c
305     SELECT t1.*, t2.* FROM t2 FULL OUTER JOIN t1 ON b=c
316     SELECT * FROM t1 FULL OUTER JOIN t2 ON b=c WHERE a IS NULL ORDER BY +d;
323     SELECT * FROM t1 FULL OUTER JOIN t2 ON b=c AND d<=0 ORDER BY +b, +d;
336       FROM t2 FULL OUTER JOIN t1 ON b=c AND d<=0 ORDER BY +b, +d;
348       FROM t2 FULL OUTER JOIN t1 ON b=c AND d<=0