|
|
Posted by IchBin on 11/29/05 04:40
Brian wrote:
> Hi there
>
> I'm trying to work out how to run a query
> that checks if there are duplicated records
> in a table and then have to run a query to
> delete them (need to check if there are
> an duplicates before I delete them)
>
> the 3 fields to use as the test would be
> product, description, dnote
>
> any help / advice?
>
> Brian
>
>
>
I do not know off the top of my head. You could write a simple program,
after you sort the tables then run a program to detect the duplicate rows.
I will say that after you clean it up make sure you define primary keys,
unique indexes and Foreign keys to preserve the integrity of your data.
--
Thanks in Advance...
IchBin, Pocono Lake, Pa, USA
http://weconsultants.servebeer.com/JHackerAppManager
__________________________________________________________________________
'If there is one, Knowledge is the "Fountain of Youth"'
-William E. Taylor, Regular Guy (1952-)
Navigation:
[Reply to this message]
|