SELECT foo 
FROM bar 
WHERE foobar IN ( SELECT name FROM person )