SELECT
    A
  , B
  , C
FROM FOO, BAR
WHERE foo.barid = bar.barid
  AND foo.something = 'special value'