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



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


'-------------------
SELECT foo 
FROM bar 
WHERE foobar IN ('lars','peter','jørgen')