Hey everyone,
I am having trouble finding the correct code to update from multiple tables. I am afraid that the SQL commands I am trying do not work on a FoxPro database. The commands I am using are as follows:
UPDATE a_prempt;
SET payrate = a_prempl->regpay ;
FROM a_prempt ;
INNER JOIN a_prpay ;
ON a_prpay->paytype = a_prempt->paytype ;
WHERE a_prempt->prempl = a_prempl->prempl ;
AND a_prempt->emprate = .t. ;
AND a_prpay->payclas like "%REGULAR%"

Is there a way in FoxPro that I can write a similiar update statement. Every way I have tried won't compile due to errors. If it helps, the compilation errors occur on the "From" line. Thanks.