title: Bigquery delete rows that are present in another table
body: <p>I want to delete all the rows from table t1 which are present in table t2.</p>
  <pre><code>table_1 is as follows
  
  a   b   c
  1   4   3
  3   334 3
  5   4   5
  6   5   4
  4   85  3
  7   332 54
  8   46  6
  45  42  5
  7   576 6
  
  </code></pre>
  <p>and table 2 is as follows</p>
  <pre><code>a   b   c
  7   332 54
  3   334 3
  7   576 6
  </code></pre>
  <p>as mentioned I would like to delete all the rows from table t1 which are present in table t2.</p>
  <p>So I used the code</p>
  <pre><code>DELETE `projectname.datasetname.table1` t
  WHERE t IN (SELECT * from `projectname.datasetname.table2`)
  </code></pre>
  <p>but it doesn't work, what would be the ideal solution here?
  My desired result is</p>
  <pre><code>a   b   c
  1   4   3
  5   4   5
  6   5   4
  4   85  3
  8   46  6
  45  42  5
  </code></pre>
  <p>Thanks</p>