[RBASE-L] - Re: Finding Duplicate records

[Albert Berry]

Damon, you can identify duplicate charges as long as you can identify a set of columns that would be unique in correct postings. SELECT <list of columns that should be unique>, COUNT(*) + FROM <whichevertable> + GROUP BY <list of columns that should be unique> + HAVING COUNT(*) > 1 This could be saved as a view if you wanted, and checked for a row count to see if there are any duplicate charges. CREATE VIEW vwDupCharges  (Column Aliases) AS + and the select clause from above. Hope this helps Albert Gray, Damon wrote: I know I can use Delete Duplicates to blow out these records, but I’d like to list them out so someone in our accounting department can analyze them.  I don’t see a built in method of identifying duplicate records in tables.  Does such a thing exist in 6.5++ ?                  wwwww                (   @  @   ) -------oOO---(_)---OOo-------                 Damon J. Gray Anvil Corporation Business Services                    (360) 937-0770           oooo0  0oooo           (        )   (        ) ----------\    (----)     /-----------                \__)   (__/