The additional FROM is a TSQL Extension, it is not supported by ANSI SQL.

-Mike


>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