hobby:development:sql:semi_join [MLC Wiki]

SELECT *
FROM Table1 T1
WHERE EXISTS
(
	SELECT 1 
	FROM Table2 T2 
	WHERE T1.IdT2 = T2.IdT2
);