Update Prices

I want to update price of products table from an imported table B.

Here is the code:




Code Snippet
update dbo.tbl_product
set product_wholesale_price = (SELECT dbo.B.WS FROM dbo.B
where dbo.tbl_product.product_id = dbo.B.product_code)






But I am getting the following error:

Msg 107, Level 16, State 3, Line 1

The column prefix 'dbo.B' does not match with a table name or alias name used in the query.

Msg 107, Level 16, State 3, Line 1

The column prefix 'dbo.B' does not match with a table name or alias name used in the query.


Please tell me where I am wrong..or is there a better way to do it?