Lines Matching refs:ta
164 CREATE TABLE ta(a INTEGER PRIMARY KEY, b);
165 INSERT INTO ta VALUES(1,1);
166 INSERT INTO ta VALUES(2,2);
167 INSERT INTO ta VALUES(3,3);
168 INSERT INTO ta VALUES(4,4);
169 INSERT INTO ta VALUES(6,6);
170 INSERT INTO ta VALUES(8,8);
171 INSERT INTO ta VALUES(10,
173 SELECT * FROM ta WHERE a<10;
192 SELECT a FROM ta WHERE b IN (SELECT a FROM tb);
197 SELECT a FROM ta WHERE b NOT IN (SELECT a FROM tb);
202 SELECT a FROM ta WHERE b IN (SELECT b FROM tb);
207 SELECT a FROM ta WHERE b NOT IN (SELECT b FROM tb);
212 SELECT a FROM ta WHERE a IN (SELECT a FROM tb);
217 SELECT a FROM ta WHERE a NOT IN (SELECT a FROM tb);
222 SELECT a FROM ta WHERE a IN (SELECT b FROM tb);
227 SELECT a FROM ta WHERE a NOT IN (SELECT b FROM tb);
260 SELECT a FROM ta WHERE a IN ();
265 SELECT a FROM ta WHERE a NOT IN ();