select t1.id from t1 right outer join t2 on t1.id=t2.id where t2.id=null
SELECT *FROM t1WHERE t1.id_ not in (select id_ from t2)
