title: Querying multiple tables in Big Query
body: <p>As it is not possible to update data within a table in BigQuery, and supports only append mechanism, I have decided to create new tables on monthly basis. So suppose for year 2012 the tables would be (<code>tbl_012012</code>, <code>tbl_022012</code>, <code>tbl_032012</code>,...<code>tbl_122012</code>). Each record will be stored along with date <code>timestamp</code> as string. </p>
  
  <p>Now, if my application wants to fetch records ranging from Jan 2012(<code>tbl_012012</code>) to March 2012(<code>tbl_032012</code>), will BigQuery API automatically traverse through the desired tables via single SQL range query or will I have to write multiple SQL queries with extra application code to retrieve each query result and then aggregate them altogether?</p>