title: Multiple Joins causing "Syntax error in FROM clause"
body: <p>I am trying to join three tables in Access and extract one column from each table. I wrote the following query, which I think should work, but keep getting a “syntax error in FROM clause” message. What am I doing wrong?</p>
  
  <pre><code>SELECT A.ONE, B.TWO, C.THREE
  FROM (A LEFT JOIN B ON A.ONE=B.ONE)
  (LEFT JOIN C ON B.TWO=C.TWO);
  </code></pre>
  
  <p>Thank you.</p>
  
  <p>EDIT: I figured out the problem. There was a paranthesis in the wrong place. I am pasting the proper code below in case someone else also has this issue.</p>
  
  <pre><code>SELECT A.ONE, B.TWO, C.THREE
  FROM ((A LEFT JOIN B ON A.ONE=B.ONE)
  LEFT JOIN C ON B.TWO=C.TWO);
  </code></pre>
  
  <p>OR</p>
  
  <pre><code>SELECT A.ONE, B.TWO, C.THREE
  FROM (A LEFT JOIN B ON A.ONE=B.ONE)
  LEFT JOIN C ON B.TWO=C.TWO;
  </code></pre>