SELECT foo FROM bar WHERE id IN (
  SELECT id FROM baz WHERE a = b
)