>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.
Mark McCasland
Midlothian, TX USA