Subject Re: Help on query for deduplication
Author Adam

I can think of a quick way to do it but I imagine the performance may
be slow on large tables. Join may actually be left join, it depends on
your business rules.

select p.code,, c.home, c.cell,, count(*)
from p
join c on (p.code=c.code)
group by p.code,, c.home, c.cell,
having count(*) > 1