RP,

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, p.name, c.home, c.cell, c.office, count(*)
from p
join c on (p.code=c.code)
group by p.code, p.name, c.home, c.cell, c.office
having count(*) > 1

Adam