See
Re: Updating from multiple tables Message #
711746 for workaround.
>I am writing a T-SQL stored procedure that uses the FROM clause in an update statement. I wanted to test the equivalent functionality in VFP. But then I looked at the VFP help and realized that it does not appear to be supported in vfp 6 or 7. How about in 8?
>
>How can I update rows in one table in vfp based upon a join condition on two tables?
>
>TIA
--sb--