title: Joining onto itself in BigQuery
body: <p>I have this code that works in MySQL but haven't managed to get it run in BigQuery.</p>
  <pre><code>select *
  from table1 
  left join table1 as table2
  on table1.user_id = table2.user_id
  and table1.date = table2.date - interval '1 day'
  </code></pre>
  <p>I'm probably missing something fundamental here but can't figure it out.</p>