Hi all -
I have two tables - customers and documents. Each customer can be
related to several different documents. There has been a bug in some
software that's been duplicating the addition of a certain type of
document for the customers. Even though each customer can have
documents of the same type, in this case I don't want it.
customers
customer_id
...
documents
customer_id
document_id
document_type_id
...
So, for example, there are two documents with the same document_type_id
associated with one customer.
Can someone help me with a SQL statement that might help me remove the
duplicate documents for a certain document_type_id?
Thanks,
Scott.