select t1.*
from t1
left join t2
  on t2.id = t1.id
where t2.id is null