UPDATE one table with data from another

[marksie1988]

Hi,

 

i have a table which will hold products in it but first the products are imported to tempproducts so that i can update the products where there is a change i created the following update command but i keep getting the following error:

 

Msg 4104, Level 16, State 1, Line 4

The multi-part identifier "dbo.tempproduct.manf_part_no" could not be bound.

Msg 4104, Level 16, State 1, Line 5

The multi-part identifier "dbo.tampproduct.supp_id" could not be bound.

 

 

UPDATE dbo.products
SET dbo.products.avail_qty = dbo.tempproduct.avail_qty
FROM dbo.products
WHERE dbo.products.manf_part_no =  dbo.tempproduct.manf_part_no 
AND dbo.products.supp_id = dbo.tampproduct.supp_id

 

i havent been using mssql for long as i mainly use mysql so am not too sure on some things like this.

 

help appreciated

 

Steve