Hi Guys,
i created access built-in find duplicates query but i do not know how to delete from my primary table based on that table.
Because in Find duplicates query are 2 records but i only should delete 1 of them.
Can anybody help?
To precise:
I have main table with primary key.
But in this table i have duplicates- the same rows.
Data is imported from CSV file without PK.
I am creating find duplicates but i have to only keep one record from Find Duplicates Main Table query.
Please help with writing SQL for this.
Jacek
i created access built-in find duplicates query but i do not know how to delete from my primary table based on that table.
Because in Find duplicates query are 2 records but i only should delete 1 of them.
Can anybody help?
To precise:
I have main table with primary key.
But in this table i have duplicates- the same rows.
Data is imported from CSV file without PK.
I am creating find duplicates but i have to only keep one record from Find Duplicates Main Table query.
Please help with writing SQL for this.
Jacek
Last edited: