alcr

Вариантов 2:
1:
SELECT
t2.*
FROM t1 INNER JOIN t2 ON t1.id = t2.owner_id
2.
SELECT
t2.*
FROM t2 WHERE t2.owner_id IN (SELECT t1.id FROM t1)

Учите матчасть :)