>so if A is ur addlink table. How can you say delete A from Add link.
>
>Also im trying to translate your code into mine so...we are using to tables. not too sure why because we trying to mark for deletion duplicates from one table
>
>>A is an alias for AddLink table in my example. BTW, this code is taken from SQL Server, in VFP it's better to not use letters from A to J as table aliases in the select statement.
>>
>>>your first line.Is it delete A from addlink. So I take A to be a field but then u have A.address which makes it a table?is it supposed to b delete * from?
Delete myTable from myTable inner join Dups on myTable.DupKey = Dups.DupKey and myTable.PK > Dups.MinKey
If it's not broken, fix it until it is.
My Blog