Lines Matching refs:x1

20   CREATE TABLE t2(b INTEGER PRIMARY KEY, x1 INT COLLATE NOCASE);
22   SELECT * FROM t3, t2, t1 WHERE x2=b AND x1=a AND a=1;
26   INSERT INTO t2(b,x1) VALUES(11,1),(22,2),(33,3);
28   SELECT *,'|' FROM t3, t2, t1 WHERE x2=b AND x1=a AND a=1;
31   SELECT *,'|' FROM t3, t1, t2 WHERE x2=b AND x1=a AND a=1;
34   SELECT *,'|' FROM t2, t3, t1 WHERE x2=b AND x1=a AND a=1;
37   SELECT *,'|' FROM t2, t1, t3 WHERE x2=b AND x1=a AND a=1;
40   SELECT *,'|' FROM t1, t2, t3 WHERE x2=b AND x1=a AND a=1;
43   SELECT *,'|' FROM t1, t2, t3 WHERE x2=b AND x1=a AND a=1;
46   SELECT *,'|' FROM t3, t2, t1 WHERE b=x2 AND a=x1 AND 1=a;
49   SELECT *,'|' FROM t3, t1, t2 WHERE b=x2 AND a=x1 AND 1=a;
52   SELECT *,'|' FROM t2, t3, t1 WHERE b=x2 AND a=x1 AND 1=a;
55   SELECT *,'|' FROM t2, t1, t3 WHERE b=x2 AND a=x1 AND 1=a;
58   SELECT *,'|' FROM t1, t2, t3 WHERE b=x2 AND a=x1 AND 1=a;
61   SELECT *,'|' FROM t1, t2, t3 WHERE b=x2 AND a=x1 AND 1=a;