SELECT f FROM t WHERE x in (SELECT x FROM y)