Lines Matching refs:ta

167     CREATE TABLE ta(a INTEGER PRIMARY KEY, b);
168     INSERT INTO ta VALUES(1,1);
169     INSERT INTO ta VALUES(2,2);
170     INSERT INTO ta VALUES(3,3);
171     INSERT INTO ta VALUES(4,4);
172     INSERT INTO ta VALUES(6,6);
173     INSERT INTO ta VALUES(8,8);
174     INSERT INTO ta VALUES(10,
176     SELECT * FROM ta WHERE a<10;
195     SELECT a FROM ta WHERE b IN (SELECT a FROM tb);
200     SELECT a FROM ta WHERE b NOT IN (SELECT a FROM tb);
205     SELECT a FROM ta WHERE b IN (SELECT b FROM tb);
210     SELECT a FROM ta WHERE b NOT IN (SELECT b FROM tb);
215     SELECT a FROM ta WHERE a IN (SELECT a FROM tb);
220     SELECT a FROM ta WHERE a NOT IN (SELECT a FROM tb);
225     SELECT a FROM ta WHERE a IN (SELECT b FROM tb);
230     SELECT a FROM ta WHERE a NOT IN (SELECT b FROM tb);
263     SELECT a FROM ta WHERE a IN ();
271     SELECT a FROM ta WHERE a NOT IN ();
277     SELECT * FROM ta LEFT JOIN tb ON (ta.b=tb.b) WHERE ta.a IN ();