title: How do I write a full outer join query in access
body: <p>Original query:</p>
  
  <pre><code>SELECT * 
  FROM AA
  FULL OUTERJOIN BB on (AA.C_ID = BB.C_ID);  
  </code></pre>
  
  <p>How do I convert the query above to make it compatible in Microsoft Access?</p>
  
  <p>I am assuming:</p>
  
  <pre><code>SELECT *
  FROM AA
  FULL LEFT JOIN BB ON (AA.C_ID = BB.C_ID);
  </code></pre>
  
  <p>I haven't dealt with the "FULL" criteria before am I correctly converting the first query into a query compatible with Access?</p>