RE: Using SQL to check for duplicate records

--- Tom Liotta <qsrvbas@xxxxxxxxxxxx> wrote:
> But I've never done it, so don't know if it'd work. I'd probably go with
> whatever SQL seemed to work well (to keep it from being a pure RPG post
> and needing to be sent to different list.)

Well, the reason _I_ would try to keep this as an SQL solution is so I
wouldn't have to write & compile a new program for every file and every
duplicate field combo that I have had to look for.  With SQL, if we got
the gist of it to work, it would be extremely simple to check for
duplicates by other fields and/or in other files.

Someone asked about seeing what MS Access creates for SQL when doing the
search for duplicates in it.  Did anyone ever check that one out?  (Don't
have Access here, so I can't try it out.  Does Access97 generate SQL?)

GA

__________________________________
Do you Yahoo!?
Yahoo! Hotjobs: Enter the "Signing Bonus" Sweepstakes
http://hotjobs.sweepstakes.yahoo.com/signingbonus