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