Update query which USED to work
Posted: Mon Nov 21, 2005 6:58 pm
This update query used to run fine but now it just gives an error.
I have been doing some updating, so it's not impossible that something is changed, but I can see what could be wrong.
Any help here would be great.
Jcart | formated query for readability
Code: Select all
UPDATE
`tbl_vendor_product_price`,
`tbl_vendor_product`
SET
`tbl_vendor_product_price`.`cost` = `tbl_vendor_product_price`.`cost` + '0.01'
WHERE
`tbl_vendor_product`.`VI_PK` = `tbl_vendor_product_price`.`VI_ID`
AND
`tbl_vendor_product_price`.`VS_ID` = '32'
AND
`tbl_vendor_product`.`TT_ID` = '2'Any help here would be great.
Jcart | formated query for readability