Than they all have duplicates in ap2 on Id2 field.
>Its quite faster
>
>But any of the 3 shows all records instead of only duplicated
>
>I wrote as below
>
>
>SELECT * FROM ap WHERE id2 IN (SELECT id2 FROM ap2) INTO CURSOR crsDupRecs
>* or - most likely the fastest one
>*SELECT ap.* FROM ap JOIN ap2 ON ap2.id2 = ap.id2 INTO CURSOR crsDupRecs
>* or
>*SELECT * FROM ap WHERE EXISTS (SELECT 1 FROM ap2 WHERE ap2.id2 = ap.id2 ) INTO CURSOR crsDupRecs
>
>SELECT crsDupRecs
> BROWSE
--sb--