SQL Update command not working

[emcounts]

I need to update the price in one table from a field in another.

2 Tables named:
newpricelist
pricelist

I have 3 common fields in both, item, description and price. I need to match the item field and take the price from "newpricelist" table and update the price field in the "pricelist" table.

Here is my syntax (it says it will only update 1 record):
UPDATE PRICELIST INNER JOIN NEWPRICELIST ON NEWPRICELIST.ITEM = PRICELIST.ITEM SET PRICELIST.PRICE = NEWPRICELIST.PRICE;

Thank you for your help!

 

[dalchri]

UPDATE PRICELIST, NEWPRICELIST
SET PRICELIST.PRICE = NEWPRICELIST.PRICE
WHERE NEWPRICELIST.ITEM = PRICELIST.ITEM