Using SQL-Update in FoxPro 8.0
Hi,
I m trying to update a column of multiple rows in a table from a column of multiple rows from another table but havent got the required result. I have tried various queries; here are a few failed examples:
1. UPDATE expenses_fxd ;
SET expenses_fxd.postedpr = expenses_new.postedpr ;
FROM expenses_new ;
WHERE expenses_fxd.slipnum = expenses_new.slipnum
Error Msg: "Command contains unrecognized phrase/keyword."
2. INSERT INTO expenses_fxd (postedpr, postfuelpr) VALUES ((SELECT postedpr, postfuelpr FROM expenses_new WHERE expenses_new.slipnum = expenses_fxd.slipnum))
Error Msg: "Function name is missing )."
3. UPDATE expenses_fxd ;
SET postedpr = (select expenses_new.postedpr from expenses_new WHERE expenses_new.slipnum = expenses_fxd.slipnum) ;
WHERE exists (select expenses_new.postedpr from expenses_new WHERE expenses_new.slipnum = expenses_fxd.slipnum)
Error Msg: "Function name is missing )."
4. INSERT INTO expenses_fxd (postedpr, postfuelpr) ;
VALUES (SELECT (postedpr, postfuelpr) ;
FROM expenses_new ;
WHERE expenses_new.slipnum = expenses_fxd.slipnum)
Error Msg: "Too many arguments."
5. UPDATE expenses_fxd ;
SET postedpr = en.postedpr ;
from expenses_new en ;
inner join expenses_fxd ef ;
on en.slipnum = ef.slipnum
Error Msg: "Command contains unrecognized phrase/keyword."
Would anyone spot the problem and help me with the right query please?
Thanx!
