Re: SQL Too difficult for me do you know how?

Just do your normal SQL starement to produce the fields but include the ROWID field in the query. The just

     delete from <table> where rowid - <rowid>

Mark

Jobi wrote in message ...
>Hi,
>
> I have a Table with somewhat duplicate record and I would like to delete
>the duplicates Here is an Exemple of the table:
>
>RecordID ClientID AddressID
>
> 1 688 123
> 2 688 123
> 3 783 142
> 4 783 143
>
>Note: RecordID is created on Insert to provide a Unique Number to Index On.
>It is NOT ROWID
>
>Now What I would like to do is get rid of All but ONE of the Records that
>Have the Same ClientID AND AddressID....
>
>Thanks for your help....
>
>
>
>Eric
>
>
Received on Fri Mar 05 1999 - 03:02:34 CST