SQLize | PHPize | SQLtest

-- create table t1(a int); -- create table t2(a int); -- insert into t1 values(1); -- insert into t1 values(3); -- insert into t1 values(5); -- insert into t1 values(7); -- insert into t2 values(2); -- insert into t2 values(4); -- insert into t2 values(6); -- insert into t2 values(8); -- insert into t2 values(1); -- insert into t2 values(7); -- select * from t1 where a not in (select a from t2); -- select * from t1 where a in (select a from t2); -- select t1.a from t1 left join t2 on t1.a = t2.a; create table a(val int); create table b(val int); create table c(val int); insert into a values(1); insert into a values(3); insert into a values(5); insert into a values(8); insert into a values(2); insert into b values(1); insert into b values(3); insert into b values(7); insert into b values(9); insert into c values(1); insert into c values(3); insert into c values(5); insert into c values(8); insert into c values(2); explain plan for --explain select a.val from a -- join -- c -- on -- a.val = c.val where exists ( select 1 from b where a.val = b.val and b.val * b.val < 100 ); select * from table(dbms_xplan.display);