does sql manage exclusivity ?

[gandolf989]

select * from t1 where not exists ( select * from t2)
/


you can also do
select * from t1 where c1 not in (
select c1 from t2)

So the answer is yes.