>Correlated update BUG!!!!
>
>It happens when you alias the table ("y") in the correlated update in FoxPro. If you don't alias the table then FoxPro works correctly.
>

>update junk set d1 = d2 from junk y inner join junk2 on y.id = junk2.id

The issue here is that when you add the alias y in the FROM clause, you're telling the command to USE the table again. So the Junk you're updating is not the same Junk you're joining.

There's no VFP bug here, just a bug in your code.

Tamar