title: how to Delete where multiple columns IN\NOT IN other table?
body: <p>I have a target Table and a source table</p>
  
  <p>and I want to delete a row from it only if some of the column's data appear in another table (the source table)</p>
  
  <p>for example:</p>
  
  <p>Target Table to delete from it:</p>
  
  <pre><code>|  Delivery  |   Order     |     Row      |  OtherColumn |
  |:----------:|:-----------:|:------------:|:------------:|
  |     1      |     A       |    000010    |     asaf     |
  |     1      |     A       |    000020    |     ag       |
  |     2      |     C       |    000010    |     DEL      |&lt;-I WANT TO DELETE THIS ROW
  |     2      |     D       |    000020    |     hhs      |  
  |     3      |     E       |    000040    |     ba       |
  |     3      |     E       |    000170    |     ass      |
  </code></pre>
  
  <p>Source table, Here I have a row that i want to KEEP in the target table :</p>
  
  <pre><code>|  Delivery  |   Order     |     Row      |
  |:----------:|:-----------:|:------------:|
  |     2      |     D       |    000020    | 
  </code></pre>
  
  <p>the result I'm looking for the target table is:</p>
  
  <pre><code>|  Delivery  |   Order     |     Row      |  OtherColumn |
  |:----------:|:-----------:|:------------:|:------------:|
  |     1      |     A       |    000010    |     asaf     |
  |     1      |     A       |    000020    |     ag       |
  |     2      |     D       |    000020    |     hhs      |  
  |     3      |     E       |    000040    |     ba       |
  |     3      |     E       |    000170    |     ass      |
  </code></pre>
  
  <p>Meaning, all the rows for delivery number 2 would be deleted <strong>if they are not in the source table</strong></p>
  
  <p>I have the Delivery parameter as @Delivery</p>
  
  <p>what I tried is:</p>
  
  <pre><code>delete from Target 
  where Delivery = @Delivery
  and ([Delivery],[Order],[Row]) not in (select [Delivery],[Order],[Row] 
                                   from Source)
  </code></pre>
  
  <p>but there's a syntax error, I understand multiple columns are not acceptable in NOT IN operator,</p>
  
  <p>what can i do?</p>