On 1/11/06, Scott Ford <Scott.Ford@bullfrogpower.com> wrote:
> 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.
>
i think what you need is a SQL to _search_ all the cases...
then look at them... and deletes them one at a time... that's the
safer way to go...
--
regards,
Jaime Casanova
(DBA: DataBase Aniquilator ;)