Lines Matching refs:tb
180 CREATE TABLE tb(a INTEGER PRIMARY KEY, b);
181 INSERT INTO tb VALUES(1,1);
182 INSERT INTO tb VALUES(2,2);
183 INSERT INTO tb VALUES(3,3);
184 INSERT INTO tb VALUES(5,5);
185 INSERT INTO tb VALUES(7,7);
186 INSERT INTO tb VALUES(9,9);
187 INSERT INTO tb VALUES(11,
189 SELECT * FROM tb 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);
286 CREATE TABLE t4 AS SELECT a FROM tb;
302 SELECT b FROM t1 WHERE a NOT IN tb;