Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

delete duplications

Status
Not open for further replies.
iroosma

iroosma

Technical User
Jun 25, 2004
11
US
I am joining two tables together and my final product has many duplicate entries. How can I delete all of the duplicate entries.

Thanks
 
Sort by date Sort by votes
Do a distinct query into a new table and then run a second query and delete everything in your original table that exists in the new table. Then copy everything from the new table into your original table.
 
Upvote 0 Downvote
Im not sure how to do a distinct query.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

serino
  • Locked
  • Question
Delete From Table
Replies
1
Views
267
Andrzejek
Andrzejek
serino
  • Locked
  • Question
Delete with WHERE Clause. 2
Replies
4
Views
274
serino
serino
MDGarcia
  • Locked
  • Question
Error Could not delete from specified tables 2
Replies
14
Views
423
MDGarcia
MDGarcia
puforee
  • Locked
  • Question
Delete Query Error 3128 1
Replies
12
Views
127
Andrzejek
Andrzejek
misuser2k7
  • Locked
  • Question
Delete query to delete every last remaing record in group of records 1
Replies
8
Views
64
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top