Subject Re: [firebird-support] Re: Help on query for deduplication
Author Dmitry Sibiryakov
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 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.