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



'-------------------
SELECT foo 
FROM bar 
WHERE foobar IN (''+ SELECT name FROM person +'')