SELECT * FROM Table1 T1 RIGHT OUTER JOIN Table2 T2 ON T1.IdT2 = T2.IdT2 WHERE T1.IdT2 IS NULL;