title: LEFT JOINing on additional criteria in MS Access
body: <p>I have the following T-SQL query (a simple test case) running fine in MS SQL but cannot get the equivalent query in MS Access (JET-SQL). The problem is the additional criteria in the LEFT JOIN. <strong>How can I do this in MS Access?</strong></p>
  
  <p>T-SQL:</p>
  
  <pre><code>SELECT * FROM A 
  LEFT OUTER JOIN B ON A.ID = B.A_ID 
                   AND B.F_ID = 3
  </code></pre>
  
  <p>JET-SQL (what I have so far but crashes Access!):</p>
  
  <pre><code>SELECT * FROM dbo_A 
  LEFT JOIN dbo_B ON (dbo_A.ID = dbo_B.A_ID AND dbo_B.F_ID = 3)
  </code></pre>