On 25 Aug 2005 at 17:07, Rajesh Punjabi wrote:

>Now P is the master and C is the detail table. What I want to know is
>the list of people in P who have the similar contact details.

If you need list of people without much detail, try this:

Select P.name from P join C C1 ON C1.Code=P.Code join C C2 ON
(C1.Contact_Value=C2.Contact_Value and C1.Code<>C2.Code)

--
SY, Dimitry Sibiryakov.