Lines Matching refs:b3
421 CREATE TABLE b3 ( a, b, PRIMARY KEY (a, b) );
424 INSERT INTO b3 VALUES (1, 1), (1, 2);
430 SELECT * FROM b3 WHERE (SELECT b3.a, b3.b) IN ( SELECT a, b FROM b5 )
433 SELECT * FROM b3 WHERE (VALUES(b3.a, b3.b)) IN ( SELECT a, b FROM b5 );
436 SELECT * FROM b3 WHERE (b3.a, b3.b) IN ( SELECT a, b FROM b5 );
439 SELECT * FROM b3 JOIN b4 ON b4.a = b3.a
440 WHERE (SELECT b3.a, b3.b) IN ( SELECT a, b FROM b5 );
443 SELECT * FROM b3 JOIN b4 ON b4.a = b3.a
444 WHERE (VALUES(b3.a, b3.b)) IN ( SELECT a, b FROM b5 );
447 SELECT * FROM b3 JOIN b4 ON b4.a = b3.a
448 WHERE (b3.a, b3.b) IN ( SELECT a, b FROM b5 );