title: Joining multiple tables in bigquery
body: <p>I would like to be able to join multiple tables in bigquery.  Joining two is pretty trivial.</p>
  
  <pre><code>SELECT
  t1.field1 AS field1,
  t2.field2 AS field2,
  t1.field3 AS field3
  FROM [datasetName.tableA] t1
  JOIN [datasetName.tableB] t2
  ON t1.somefield = t2.anotherfield
  </code></pre>
  
  <p>But what if I want to join three or more tables? Can I just do it as</p>
  
  <pre><code>SELECT
  t1.field1 AS field1,
  t2.field2 AS field2,
  t1.field3 AS field3,
  t3.field4 as field4
  FROM [datasetName.tableA] t1
  JOIN [datasetName.tableB] t2
  JOIN [datasetName.tableC] t3
  ON t1.somefield = t2.anotherfield AND t1.somefield=t3.yetanotherfield
  </code></pre>
  
  <p>I've tried that and it doesn't work.  I think I need to do something like</p>
  
  <pre><code>SELECT 
  t12.field1 as field1,
  t12.field2 as field2,
  t3.field3 as field3,
  FROM
  (SELECT
  t1.field1 AS field1,
  t2.field2 AS field2,
  t1.field3 AS field3
  FROM [datasetName.tableA] t1
  JOIN [datasetName.tableB] t2
  ON t1.somefield = t2.anotherfield) t12
  JOIN
  [datasetName.tableC] t3
  ON t12.field1 = t3.field1 
  </code></pre>
  
  <p>But is there a simpler way to accomplish this?</p>
  
  <p>Thanks,
  Brad</p>