>>re-read my earlier post...
>
>No, I won't read your earlier post again. It made no sense. I have clearly laid out the correct syntax and have posed the BIG QUESTION where SQL Server gets the answer correct which you have not addressed.
>
>End of the Discussion is that the following is the correct FoxPro (not SQL Server) syntax. Read the FoxPro Help. I have no idea what your code is all about other than it doesn't make any sense at all.
>
>update y set y.d1 = x.d2 from junk y inner join junk2 x on y.id = x.id &&works correctly
>
>Note: That it is "update y" not "update junk" and that's what the FoxPro Help says to do.
It's correct SQL Server syntax as well. It clearly shows what is updated and what is the source for update. I would never rely on SQL Server behavior when it silently disregards an alias and consider 'junk' an 'y' as the same table.
--sb--