title: Is it possible to add two IQueryable's together?
body: <p>I've been using Union on IQueryable&lt;> (with the same type) to try to get one collection produced from two collections, but it is not working. I believe my understanding is at fault with regards to the IQueryable members.</p>
  
  <p>I thought I could use the union method to build (within a foreach) a SQL statement which would execute something like:</p>
  
  <pre><code>SELECT * FROM MYTABLE WHERE FK = 1
  UNION
  SELECT * FROM MYTABLE WHERE FK = 9
  UNION
  SELECT * FROM MYTABLE WHERE FK = 15
  </code></pre>
  
  <p>Previously I had thought that there must be an method available which produces the same effect on two IQueryable's as the old favourite ArrayList's AddRange, which is really the basic of what I'm trying to achieve here.</p>