BigQuery: Querying multiple datasets and tables using Standard SQL
<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>