select * from t1, t2
where t1.t1_id = t2.t1_id

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