title: is it possible to use a subquery instead of a table in from clause using access?
body: <p>In MS ACCESS, is it possible to:</p>
  
  <p>use a subquery instead of the first table in a from clause? </p>
  
  <p>(Code below edited with the suggestions by the wonderful people who helped me)</p>
  
  <p>Example:</p>
  
  <pre><code>Part 1 (now working):
      FROM
      (SELECT [Distributor2].PRODUCTCODE
        FROM [Distributor2]
  
        UNION
  
       SELECT [DISTRIBUTOR3].PRODUCTCODE
        FROM [DISTRIBUTOR3]
  
        UNION
  
       SELECT [DISTRIBUTOR1].PRODUCTCODE
        FROM [DISTRIBUTOR1]
      ) AS [ALLPRODUCTCODES]
  </code></pre>
  
  <p>INCLUDING PART 2 (now working! Even my multiple join conditions!!!). I've renamed the ALLPRODUCTSCODES table "Table 1" below so it is clearer:</p>
  
  <pre><code>  FROM ((((subqueryabove) AS [TABLE1])
  LEFT JOIN [TABLE2] on (Table2.productcode = Table1.productcode AND Table2.year=2013))
  LEFT JOIN [TABLE3] on (Table3.productcode = Table1.productcode AND Table3.year=2013))
  LEFT JOIN [TABLE4] on (Table4.productcode = Table1.productcode AND Table4.year=2013)
  </code></pre>
  
  <p>(code edited from first two replies' suggestions - Thank you for your help with MSAccess bracket craziness!!!)</p>