title: Using update with Left Join BigQuery
body: <p>I am trying to write an Update query with LEFT JOIN in BigQuery but I am not sure how to write it.</p>
  <pre><code>  update Table1
    set ColumnTest =  ifnull(b.value, 'no run')
    From left join  (select distinct ID,value FROM Table2 where value = 10) B  --
    where Table1.ID= Table2.ID
  </code></pre>
  <p>I have 2 tables Table1 and Table2</p>
  <p>I want to update Table1.ColumnTest with Table2.Value where Table1.ID= Table2.ID
  and if Table1 &lt;&gt; Table2 then update Table1.ColumnTest with 'no run'</p>
  <p>Thanks!!</p>
  <p>New Try</p>
  <pre><code>  UPDATE Table1
    SET LP = IFNULL(t2.value, 'no run')
    FROM (     select distinct hits.eventInfo.eventCategory as ID, value
         FROM Table2
         CROSS JOIN UNNEST (hits) AS hits
         left join  TAble1 using (hits.eventInfo.eventCategory)
         WHERE) t2
   WHERE t1.ID = t2.ID
  </code></pre>
  <p>Error:  Syntax error: Expected &quot;)&quot; or &quot;,&quot; but got &quot;.&quot;</p>