title: Left outer join in access?
body: <p>Following query does not work in access.</p>
  
  <pre><code>SELECT Fields.FieldId, PrecisionSettings.DecimalPlaces 
  
      from Fields left outer join FieldGroup on Fields.FieldGroupId = FieldGroup.FieldGroupId
  
      left outer join Category on FieldGroup.CategoryId = Category.CategoryId
  
      left outer join PrecisionSettings on 
  
      Category.InputAttributesID=PrecisionSettings.AttributesID
  </code></pre>
  
  <p>It gives error as missing operator in query expression.</p>