title: Syntax error (missing operator) in query expression (ms access)
body: <p>I am trying to run this code to access however it is giving me this error. I check other sites with related problem and it state that I need to put a parenthesis if there is 2 more joins. I been trying but no luck.</p>
  
  <pre><code>         select *
            from 
               (
                  select group_id from tbl_group
                  union 
                  select group_id from table_group\website
               )a
              left outer join  tbl_group  on a.group_id = tbl_group.group_id
              left outer join  table_group\website on a.group_id=table_group\website.group_id;
  </code></pre>