Subject Re: [IBDI] Duplictes query
Author Helen Borrie
Could you take this to the ib-support list please?


At 03:39 PM 05-06-01 +0100, you wrote:
>I have a straightforward name & address table,
>each record has a unique ID (primary key)
>I need to identify the ID of those records
>that are duplicated across the name and address
>fields, possibly with some degree of mismatch (ie
>a %LIKE% element)
>Cannot figure out the SQL at all as COUNT
>just tells me I have duplicates, not which
>they actually are
>Roger Pullen
>Community email addresses:
> Post message:
> Subscribe:
> Unsubscribe:
> List owner:
>Shortcut URL to this page:
>Your use of Yahoo! Groups is subject to

All for Open and Open for All
InterBase Developer Initiative ยท