J
Joseph
Hi,
I'm trying to delete duplicate records from 1 main table that i have.
It is Access DB is linked table on the SQL server. I can manually
delete the record but I cannot do it by query.
Here is the SQL query:
DELETE DISTINCTROW [dbo_CP Table 1].*, Distinct.[Identifier Field]
FROM [dbo_CP Table 1] INNER JOIN [Find duplicates for dbo_CP Table 1] AS
[Distinct] ON [dbo_CP Table 1].Identifier = Distinct.[Identifier Field]
WHERE (((Distinct.[Identifier Field])=[Distinct].[Identifier Field]));
I'm trying to delete duplicate records from 1 main table that i have.
It is Access DB is linked table on the SQL server. I can manually
delete the record but I cannot do it by query.
Here is the SQL query:
DELETE DISTINCTROW [dbo_CP Table 1].*, Distinct.[Identifier Field]
FROM [dbo_CP Table 1] INNER JOIN [Find duplicates for dbo_CP Table 1] AS
[Distinct] ON [dbo_CP Table 1].Identifier = Distinct.[Identifier Field]
WHERE (((Distinct.[Identifier Field])=[Distinct].[Identifier Field]));