Lines Matching refs:t1

26   CREATE TABLE t1(a INTEGER PRIMARY KEY);
30   INSERT INTO t1 VALUES(1),(2),(3);
39   SELECT t1.a
40     FROM t1, t2, t3
41    WHERE t1.a=t2.c AND t2.b=t3.d
42    ORDER BY t1.a;
45   SELECT t1.a
46     FROM t1, t2, t3
47    WHERE t1.a=t2.c AND t2.b=t3.d
48    ORDER BY t1.a DESC;
51   SELECT t1.a
52     FROM t1 CROSS JOIN t2 CROSS JOIN t3
53    WHERE t1.a=t2.c AND t2.b=t3.d
54    ORDER BY t1.a;
57   SELECT t1.a
58     FROM t1 CROSS JOIN t2 CROSS JOIN t3
59    WHERE t1.a=t2.c AND t2.b=t3.d
60    ORDER BY t1.a DESC;
63   SELECT t1.a
64     FROM t1 CROSS JOIN t3 CROSS JOIN t2
65    WHERE t1.a=t2.c AND t2.b=t3.d
66    ORDER BY t1.a;
69   SELECT t1.a
70     FROM t1 CROSS JOIN t3 CROSS JOIN t2
71    WHERE t1.a=t2.c AND t2.b=t3.d
72    ORDER BY t1.a DESC;
75   SELECT t1.a
76     FROM t2 CROSS JOIN t1 CROSS JOIN t3
77    WHERE t1.a=t2.c AND t2.b=t3.d
78    ORDER BY t1.a;
81   SELECT t1.a
82     FROM t2 CROSS JOIN t1 CROSS JOIN t3
83    WHERE t1.a=t2.c AND t2.b=t3.d
84    ORDER BY t1.a DESC;
87   SELECT t1.a
88     FROM t2 CROSS JOIN t3 CROSS JOIN t1
89    WHERE t1.a=t2.c AND t2.b=t3.d
90    ORDER BY t1.a;
93   SELECT t1.a
94     FROM t2 CROSS JOIN t3 CROSS JOIN t1
95    WHERE t1.a=t2.c AND t2.b=t3.d
96    ORDER BY t1.a DESC;
99   SELECT t1.a
100     FROM t3 CROSS JOIN t1 CROSS JOIN t2
101    WHERE t1.a=t2.c AND t2.b=t3.d
102    ORDER BY t1.a;
105   SELECT t1.a
106     FROM t3 CROSS JOIN t1 CROSS JOIN t2
107    WHERE t1.a=t2.c AND t2.b=t3.d
108    ORDER BY t1.a DESC;
111   SELECT t1.a
112     FROM t3 CROSS JOIN t2 CROSS JOIN t1
113    WHERE t1.a=t2.c AND t2.b=t3.d
114    ORDER BY t1.a;
117   SELECT t1.a
118     FROM t3 CROSS JOIN t2 CROSS JOIN t1
119    WHERE t1.a=t2.c AND t2.b=t3.d
120    ORDER BY t1.a DESC;