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?