title: SQL Union on multiple Google Sheets / Workbooks
body: <p>I have two Google Sheets Workbooks.  They both have data in columns A through J.</p>
  
  <p>I can import the ranges into a single workbook and name the data range, and a query works on one at a time:  <code>=QUERY(Phone, "Select A,B,C,G,H,I,J", 1)</code></p>
  
  <p>I've tried a couple different ways to Union the data, but nothing works quite like what I have in mind. </p>
  
  <p>If it were SQL, I would do:</p>
  
  <pre><code>Select new.A, new.B, new.C, new.D
   from (
  select A, B, C, D from Table1
  Union
  Select A, B, C, D from Table2
       )new
  where new.A = 'incomplete'
  </code></pre>
  
  <p>edit1:
  I was able to get this to work, but I'm not sure if there is a better way:</p>
  
  <p>*phone and web are my named ranges<br>
  <code>=unique({QUERY({Phone}, "Select Col2, Col3, Col7", 1);query({Web}, "Select Col2, Col3, Col7",1)})</code></p>