title: How Should This SQL with Left Joins be Written in Access 2007?
body: <p>I have a sql statement with multiple left joins that I cannot get to work in Access 2007, the message stating,</p>
  
  <blockquote>
    <p>JOIN expression not supported</p>
  </blockquote>
  
  <pre><code>SELECT
    Foo.A,
    Bar.B,
    Baz.C,
    Bat.D
  FROM
    Foo
  LEFT JOIN
    Bar ON Foo.BarId = Bar.BarId
  LEFT JOIN
    Baz ON Foo.BazId = Baz.BazId
  LEFT JOIN
    Bat ON Foo.BatId = Bat.BatId
  
  WHERE 
    Foo.CriteriaColumn = 1
  </code></pre>
  
  <p>What is the correct format for Access 2007?</p>