Forum Post: Finding Out Duplicate Records

  • Thread starter Thread starter vignesh kumar
  • Start date Start date
Status
Not open for further replies.
V

vignesh kumar

Guest
Hi All, Could you please help me in the below issue. I need to compare two tables and find out the duplicates. For eg: Customer A and customer B are two tables, table A and B has same fields and values but table A has 2 records one record with same fields& values as table B and other record only with difference in field document number. So i need to compare the two tables and export the record which has different document number. After exporting i need to delete the record also. Could you please give me a query for this?

Continue reading...
 
Status
Not open for further replies.
Back
Top