title: delete records from 2 tables after testing to see if they are duplicates
body: <p>Editing someone else's SQL Server design here:</p>
  
  <p>I have been tasked with removing duplicate rows from a database.</p>
  
  <p>I have 2 tables: <code>table1</code> and <code>table2</code>.</p>
  
  <ul>
  <li><code>table1</code> has columns <code>T1ID, and T1NAME</code></li>
  <li><p><code>table2</code> has columns <code>T2ID, DATA1, DATA2, DATA3</code></p></li>
  <li><p>Tables join on <code>T1ID = T2ID</code></p></li>
  </ul>
  
  <p>If several rows have the same <code>T1NAME, DATA1, DATA2</code>, <strong>AND</strong> <code>DATA3</code>, I need to remove all but one of them from both tables.</p>