>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
Unfortunately it doesn't :( And AFAIK not in VFP8 either (but added to insert-SQL). First do SQL for joined tables then update (probably with scan..endscan)
Cetin