Hi there,
How can i remove the duplicate records with the below 2 tables?
S/No 105 and 107 export to excel sheet are duplicate .
As shown in the attached pics.
Hi okl,
The duplicate records are in your "Load Table" table.
If this table has a primary key, then use the key to select and delete those records with a delete query. Otherwise, you can do it manually by looking for the common fields you've already discovered in your make-table query.
Cheers,
Docendo discimus.
Please consider:
- Thanking those who helped you. Click the reputation icon
in the contributor's post and add Reputation.
- Cleaning up when you're done. Mark your thread [SOLVED] if you received your answer.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks