I have two tables,
create table t1(
col11 int,
col12 int,
col13 int)
and
create table t2(
col21 int,
col22 int)
I tried to write a sql statement as follow to get what exist in t1 but not in t2 and vice versa.
>select * from t1
where (col11, col12) not exists (select col21, col22 from t2)...