| From: | "Scott Ford" <Scott(dot)Ford(at)bullfrogpower(dot)com> |
|---|---|
| To: | <pgsql-novice(at)postgresql(dot)org> |
| Subject: | Removing duplicate entries |
| Date: | 2006-01-11 19:06:53 |
| Message-ID: | CAA10533F41BB7448F7659D4D0671907347C6A@cx41.800onemail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jaime Casanova | 2006-01-11 20:05:37 | Re: Removing duplicate entries |
| Previous Message | Luis Silva | 2006-01-11 19:00:18 | Re: convert bool result query |