D
DW
I am attempting to delete duplicate records of the same table, where they are
only different on one field, by making a duplicate of the table, and doing a
self join in a delete query. The query is unable to determine which copy of
the table to delete from. How do you specify which table to delete from
either in design view or in SQL?
only different on one field, by making a duplicate of the table, and doing a
self join in a delete query. The query is unable to determine which copy of
the table to delete from. How do you specify which table to delete from
either in design view or in SQL?