hobby:development:sql:left_outer_join_we [MLC Wiki]

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