>Since we're using INNER JOIN, only records that joined, would be deleted. According to Hugo's blog I gave you in the very top of this thread, it may be not ANSI standard to use JOIN in Update/DELETE commands.
>
>Alternative way to write the same delete would be
>
>delete from myTable where fName in (select fName from Dups)
>
>---------------------------------------------------------------------------------------------------------------------------
>BTW, last night I think I invented an interesting way to number records in one replace command, planned to even test it this morning, but forgot, of course.
>
>I may try it now then.


or or or u could tell me an ill test it for you :D