select * from t1 where not exists(select 1 from t2 where col=t1.col)--
union all
select * from t2 where not exists(select 1 from t1 where col=t2.col)--
select *,[表]='t1有t2沒'
from
(select * from t1
except
select * from t2)t1
union all
select *,[表]='t2有t1沒'
from
(select * from t2
except
select * from t1)t2
----------相同
select * from t1
intersect
select * from t2