title: Deleting duplicates in mysql (2 tables)
body: <p>I have two tables (id_test, test) , each of them has an ID column, which is unique, and two entries with the same id in the two tables are the same. Now, i have another column in one of the tables (id_test) that also should be unique, so I want to eliminate duplicates according to this other column, let's call it YD.</p>
  
  <p>To identify the duplicates I used</p>
  
  <pre><code>SELECT ID, YD AS x, COUNT(*) AS y
  FROM id_test 
  GROUP BY x 
  HAVING y&gt;1;
  </code></pre>
  
  <p>now, I want to delete these entries in both tables. How can I do it?</p>