2000: select * from T1 where binary_checksum(*) not in(select binary_checksum(*) from T2) select * from T2 where binary_checksum(*) not in(select binary_checksum(*) from T1)
select b.* from a left join b on a.col=b.col where b.col is null
2005 select * from t1 except select * from T2 select * from T2 except select * from T1
select * from table1 a where not exists(select 1 from table2 where a.id = id)
select * from table1 a where not exists(select 1 from table2 where col =a.col )
select * from tb a where not exists(select 1 from tb2 where id = a.id)
select * from T1 where binary_checksum(*) not in(select binary_checksum(*) from T2)
select * from T2 where binary_checksum(*) not in(select binary_checksum(*) from T1)
from a
left join b
on a.col=b.col
where b.col is null
select * from t1
except
select * from T2
select * from T2
except
select * from T1
from table1 a
where not exists(select 1 from table2 where a.id = id)
from tb a
where not exists(select 1 from tb2 where id = a.id)