----
[[:hobby:development:sql:left_anti_semi_join:sample|{{ :hobby:development:sql:select:anti_semi_join.png?300 |}}]]
----
<sxh sql>
SELECT 
	*
FROM Table1 T1
WHERE NOT EXISTS
(
	SELECT 1 
	FROM Table2 T2 
	WHERE T1.IdT2 = T2.IdT2    
);
</sxh>