Need help on de-duping records

[ozgirl]

In one single database I'm trying to de-dupe the records that fit the criteria if [ADDRESS_1] matches [ADDRESS_1] in another record show me the results.
I'm using Visual Foxpro version 7.0 and typing
FROM ffdbc!ffdonor;
WHERE Ffdonor.address_1 = Ffdonor.address_1 = .t.
This is bringing up all the records in the database without filtering my criteria
I'm really hoping someone can help me.
Regards
Katie
katie@flyingflowers.com.au

 

[ramani]

Hi

SELECT * FROM ffdbc!ffdonor ;
WHERE Ffdonor.address_1 IN ;
(SELECT Ffdonor.address_1 FROM ffdbc!ffdonor ;
GROUP BY address_1 HAVING COUNT(address_1) > 1) ;
INTO CURSOR myDuplicates
BROWSE

You can also look in this link..

http://winnersoft.coolfreepages.com/vfp/duplicates.htm

ramani
(Subramanian.G)

http://winnersoft.coolfreepages.com/

 

[ozgirl]

Thanks heaps - that was fantastic. I've been working on this for 1/2 a day and you've fixed it for me within 1/2 an hour of me posting my problem
Thanks again.
Katie