title: BigQuery: Querying multiple datasets and tables using Standard SQL
body: <p>I have Google Analytics data that's spread across multiple BigQuery datasets, all using the same schema. I would like to query multiple tables each across these datasets at the same time using BigQuery's new Standard SQL dialect. I know I can query multiple tables within a single database like so:</p>
  
  <pre><code>  FROM `12345678`.`ga_sessions_2016*` s
    WHERE s._TABLE_SUFFIX BETWEEN '0501' AND '0720'
  </code></pre>
  
  <p>What I can't figure out is how to query against not just <code>12345678</code> but also against <code>23456789</code> at the same time.</p>