title: How to use union in sub query with Access database
body: <p>I'm working on a WinForms application with an Access database.
  Please correct me.</p>
  <pre><code>Select * 
  from EMP 
  where Empid in 
      (Select id 
       from Test1 
       where pin=4 
       UNION 
       Select id 
       from Test2 
       where pin=4) 
  </code></pre>
  <p>When I try to execute this on the Access database, it gave me this error:</p>
  <blockquote>
  <p>Operations are not allowed in subquery</p>
  </blockquote>