title: Standard SQL: LEFT JOIN by two conditions using BETWEEN
body: <p>I have the following query in BigQuery:</p>
  
  <pre><code>#Standard SQL
  
  SELECT *
  FROM `Table_1`     
  LEFT JOIN `Table_2` ON (timestamp BETWEEN TimeStampStart AND TimeStampEnd)
  </code></pre>
  
  <p>But I get the following Error:</p>
  
  <pre><code>Error: LEFT OUTER JOIN cannot be used without a condition that is an equality of fields from both sides of the join.
  </code></pre>
  
  <p>If I use JOIN instead of LEFT JOIN, it works, but I want to keep all the rows from Table_1 (so also the ones which aren't matched to Table_2)</p>
  
  <p>How to achieve this?</p>