title: Google spreadsheets Query Language get data from many other sheet
body: <p>How I can get data from many sheets? In documentation <a href="https://support.google.com/docs/bin/answer.py?hl=en&amp;answer=75943&amp;ctx=cb&amp;src=cb&amp;cbid=-1qyjxl0cyc7v6&amp;cbrank=4" rel="nofollow">Reference data from other sheets</a> is an example</p>
  
  <pre><code>=Sheet1!A1
  </code></pre>
  
  <p>I wrote test query and it's works</p>
  
  <pre><code>=Query(otherSheet!A1:P999, "select A, B, C")
  </code></pre>
  
  <p>But I want get data with one query from many tables. is it possible? How I can?</p>
  
  <p>---UPDATE---</p>
  
  <p>For example I have 2 sheet as <code>clients</code> and <code>orders</code>, and I want get username who buy some product last month. I found solutions, for example I get <code>cient_id</code> from <code>order table</code>, and then I get <code>username</code> from <code>clients</code> table</p>
  
  <pre><code>=Unique(Query(orders!A1:P999, "select D WHERE I = 'paid' and J &gt; date '2010-01-15' LABEL D 'client_id' "))
  
  =vlookup(A2,contacts!B:C,2,false)
  </code></pre>
  
  <p>You can write it with single query?</p>