>>The VFP7 help isn't lying when it says that "subqueries are supported in UPDATE – SQL" but it doesn't specify that they are only supported in the WHERE
>
>Sergey,
>
>Where does it say that?
In VFP 6 and VFP 7 help under 'UPDATE - SQL Command'. Here's an excerpt:
"Remarks
UPDATE - SQL can only update records in a single table. Note that subqueries are supported in UPDATE – SQL."
--sb--