Lines Matching refs:ta
166 CREATE TABLE ta(a INTEGER PRIMARY KEY, b);
167 INSERT INTO ta VALUES(1,1);
168 INSERT INTO ta VALUES(2,2);
169 INSERT INTO ta VALUES(3,3);
170 INSERT INTO ta VALUES(4,4);
171 INSERT INTO ta VALUES(6,6);
172 INSERT INTO ta VALUES(8,8);
173 INSERT INTO ta VALUES(10,
175 SELECT * FROM ta WHERE a<10;
194 SELECT a FROM ta WHERE b IN (SELECT a FROM tb);
199 SELECT a FROM ta WHERE b NOT IN (SELECT a FROM tb);
204 SELECT a FROM ta WHERE b IN (SELECT b FROM tb);
209 SELECT a FROM ta WHERE b NOT IN (SELECT b FROM tb);
214 SELECT a FROM ta WHERE a IN (SELECT a FROM tb);
219 SELECT a FROM ta WHERE a NOT IN (SELECT a FROM tb);
224 SELECT a FROM ta WHERE a IN (SELECT b FROM tb);
229 SELECT a FROM ta WHERE a NOT IN (SELECT b FROM tb);
262 SELECT a FROM ta WHERE a IN ();
267 SELECT a FROM ta WHERE a NOT IN ();