D
DW
I am attempting to delete duplicate records from the same table, where there
is a difference in only one field. I have a self-joined table in a delete
query. How do you designate, either in design view or in SQL, the table from
which to delete the records, as in this instance there is two copies of the
same table.
is a difference in only one field. I have a self-joined table in a delete
query. How do you designate, either in design view or in SQL, the table from
which to delete the records, as in this instance there is two copies of the
same table.