Re: Removing duplicate entries

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 ;)