>>>I was not sure if VFP6 accepts:
>>>UPDATE ...;
>>>FROM ....;
>>>INNER JOIN ....
>>
>>update it can to be slow a lot,
>>join is not required here
>>
>>UPDATE WOMaster SET WOPrinted = .T. WHERE WONumber IN (SELECT WONumber FROM workorders)
>>
>
>You may also write it using EXISTS, could be quicker.
No, never I have see a speed difference with EXISTS and IN