Delete query

  • Thread starter Thread starter Bob
  • Start date Start date
B

Bob

I have a table. the table has a field called "product_id". there are many
records with the same product_id. I would like to run a query that will
delete all the duplicate records so I end up with only one record with a
unique product_id.

thank you for any help
bob
 
Create a query that return the unique records, group by query or Select
distinct ...
When the query will return the desire records, change it from select records
query to create table query, and create a new table with unique records, then
you can rename that table and add keys to it.
 
Back
Top