Lines Matching refs:k

111   CREATE TABLE t2_a(k INTEGER PRIMARY KEY, v TEXT);
112   CREATE TABLE t2_b(k INTEGER PRIMARY KEY, v TEXT);
120     INSERT INTO t2_a SELECT new.k, new.v WHERE (new.k%2)==0;
121     INSERT INTO t2_b SELECT new.k, new.v WHERE (new.k%2)==1;
128   SELECT * FROM t1, t2 WHERE x=k;
134   SELECT * FROM t1 LEFT JOIN t2 ON (x=k);
142   SELECT x1.*, x2.* FROM t2 AS x1, t2 AS x2 WHERE x1.k=x2.k+1
150   SELECT * FROM t1, t2 WHERE x=k ORDER BY y;
158   SELECT * FROM t1, t2 WHERE x=k ORDER BY y||'';
166   SELECT * FROM t1, t2 WHERE x=k ORDER BY v
174   SELECT * FROM t1, t2 WHERE x=k ORDER BY v||''
182   SELECT * FROM t1, t2 WHERE x=k ORDER BY k,v||''
190   SELECT * FROM t1, t2 ORDER BY +k
206   SELECT * FROM t1, t2 ORDER BY k
226   CREATE TABLE t3_a(k INTEGER PRIMARY KEY, v TEXT);
228   CREATE TABLE t3_b(k INTEGER PRIMARY KEY, v TEXT);
236   SELECT * FROM t1, t3 ORDER BY k;
251   CREATE TABLE t3_a(k INTEGER PRIMARY KEY, v TEXT);
253   CREATE TABLE t3_b(k INTEGER PRIMARY KEY, v TEXT);
262   SELECT * FROM t1, t3 ORDER BY k;
266   SELECT * FROM (SELECT * FROM t1, t3) ORDER BY k;
275   ORDER BY k;
294   ORDER BY k;
301     SELECT * FROM t1 LEFT JOIN t3 ON a=k
319   CREATE TABLE t2(k,v);
324   CREATE TABLE t3_a(k INTEGER PRIMARY KEY, v TEXT);
327   CREATE TABLE t3_b(k INTEG5R PRIMARY KEY, v TEXT);
339       INSERT INTO t3_a SELECT new.k, new.v WHERE (new.k%2)==0;
340       INSERT INTO t3_b SELECT new.k, new.v WHERE (new.k%2)==1;
344 … JOIN t2 ON (a NOT IN(SELECT v FROM t1, t3 WHERE a=k)=NOT EXISTS(SELECT 1 FROM t1 LEFT JOIN t3 ON …
347   SELECT *, '+' FROM t1 LEFT JOIN t3 ON (a NOT IN(SELECT v FROM t1 LEFT JOIN t2 ON (a=k))=k);