Hi

I have table A with colums ID and Product. I have table B with ID (same as table A) and revenue of product.

I need to update the field Product of table A with the revenue of table B.

I'm confuse with the update joining both tables. I tried this, but obviously has an error:

Update A set Product=B.Revenue where A.ID=B.ID

Can you please help?

thanks,

Ezequiel

Why would you update Product column with the Revenue? This makes very little sense.

Please post your tables structures, some data (as insert statements) and desired output.

Hi,

Please try below SQL script;

UPDATE A SET Product = B.Revenue
FROM B INNER JOIN A ON B.ID = A.ID 

Hi,

Please try below SQL script;

UPDATE A SET Product = B.Revenue
FROM B INNER JOIN A ON B.ID = A.ID 

It is old Sybase proprietary syntax. It is also unpredictable. Google it.

Hi,

Please try below SQL script;

UPDATE A SET Product = B.Revenue
FROM B INNER JOIN A ON B.ID = A.ID 

It is old Sybase proprietary syntax. It is also unpredictable. Google it.