>Is it possible to update all records of a table using an update something like:
>
>update table1 set field1 = select field1 from table2 where field2 = table1.field2
>
>The above does not work. Am I hoping for too much?

I do not think subqueries are supported in VFP SQL Updates and Deletes. They are only supported in Selects.