title: Convert Access delete distinctrow (multi table delete) to TSQL
body: <p>I have this query ... I need to change this to a TSQL supported statement ... I believe I need to change to where not exists ... but do I also need 3 delete statments (a delete for each table?)</p>
  
  <pre><code>DELETE DISTINCTROW TABLE1.*, TABLE2.column1, TABLE3.column2
  FROM (
    TABLE1 LEFT JOIN TABLE2 ON (TABLE1.column3 = TABLE2.column3)
      AND (TABLE1.column1 = TABLE2.column1)
    )
  LEFT JOIN TABLE3 ON (TABLE1.column3 = TABLE3.column3)
    AND (TABLE1.column1 = TABLE3.column2)
  WHERE (
      ((TABLE2.column1) IS NULL)
      AND ((TABLE3.column2) IS NULL)
      );
  </code></pre>