title: Delete duplicates records between two tables
body: <p>I have two different tables which is users and client. There are many duplicate records. I've tried to remove those duplicates records and saved into one new table but failed. It removes the rows not the records. Are there any query to removes those duplicate records from the two tables?</p>
  <p>For example have this rows:</p>
  <blockquote>
  <p>| car | house | food |</p>
  <p>| car | cycle | shoe |</p>
  <p>| bus | water | house|</p>
  </blockquote>
  <p>The car and house are the duplicate records. I want to remove them and left the other records in a new table using the GROUP BY.</p>