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