Lines Matching refs:a2

42   CREATE TABLE a2(x BLOB, y BLOB);
43   INSERT INTO a2(x, y) VALUES(1, 1);
44   INSERT INTO a2(x, y) VALUES(2, '2');
45   INSERT INTO a2(x, y) VALUES('3', 3);
46   INSERT INTO a2(x, y) VALUES('4', '4');
50   SELECT x, typeof(x), y, typeof(y) FROM a2 ORDER BY rowid
59   SELECT (SELECT rowid FROM a1 WHERE a=x AND b=y) FROM a2
62   SELECT (SELECT rowid FROM a1 WHERE (a, b) = (x, y)) FROM a2
66   SELECT a1.rowid FROM a1, a2 WHERE a=x AND b=y;
69   SELECT a1.rowid FROM a1, a2 WHERE (a, b) = (x, y)
74   SELECT a1.rowid FROM a1, a2 WHERE coalesce(NULL,x)=a AND coalesce(NULL,y)=b
77   SELECT a1.rowid FROM a1, a2 
82   SELECT a1.rowid FROM a1, a2 WHERE +x=a AND +y=b
85   SELECT a1.rowid FROM a1, a2 WHERE (+x, +y) = (a, b)
89   SELECT (SELECT rowid FROM a1 WHERE a=+x AND b=+y) FROM a2
92   SELECT (SELECT rowid FROM a1 WHERE (a, b) = (+x, +y)) FROM a2
95   SELECT (SELECT rowid FROM a1 WHERE (+x, +y) = (a, b)) FROM a2
99   SELECT a1.rowid FROM a1 WHERE (a, b) IN (SELECT x, y FROM a2)
102   SELECT a1.rowid FROM a1, a2 WHERE EXISTS (