title: How to query on multiple date using TABLE_QUERY() in Big Query
body: <p>I want to query on these tables using table_query(). How can I query on all the tables with date range from 2017-03-22 to 2017-03-24.<br>
  Format of my BQ tables is (auctions_other_YYYYMMDDHHM)<br>
  BQ tables are listed below:</p>
  
  <blockquote>
    <p>1.auctions_other_20170322104<br>
    2.auctions_other_20170322105<br>
    3.auctions_other_20170323206<br>
    4.auctions_other_20170323207<br>
    5.auctions_other_20170324108<br>
    6.auctions_other_20170324209 </p>
  </blockquote>
  
  <p><strong>I am using query:</strong></p>
  
  <pre><code>SELECT  * FROM
  TABLE_QUERY(chocolate_raw, "table_id contains 'auctions_others_' and
  table_id contains '20170322104' and  table_id contains '20170324209'
  ")
  WHERE
    id='f3667fd6-8329-4124-a4a2-737e637a5e7d'
  </code></pre>
  
  <p><strong>Getting Error:</strong> </p>
  
  <blockquote>
    <p>FROM clause with table wildcards matches no table</p>
  </blockquote>