title: Trying to create multiple temporary tables in a single query
body: <p>I'd like to create 3-4 separate temporary tables within a single BigQuery query (all of the tables are based on different data sources) and then join them in various ways later on in the query. </p>
  
  <p>I'm trying to do this by using multiple WITH statements, but it appears that you're only able to use one WITH statement in a query if you're not nesting them. Each time I've tried, I get an error saying that a 'SELECT' statement is expected.</p>
  
  <p>Am I missing something? I'd prefer to do this all in one query if at all possible.</p>