Update a table 1

[bjm027]

I have two tables and they are related by a common ID. tbl_1 has a unique ID and tbl_2 is related to tbl_1 through this ID.

I have a field in tbl_2 that is missing values that are stored in tbl_1. I want to update those values in tbl_2 to match that of tbl_1.

Hope this was clear. I tried and update statement using an inner join and I am not to sure that MS SQL supports inner joins or my syntax was wrong.

Any help on how the update statement would turn out to be.

Thanks in advance...

 

[SQLSister]

Please post what you wrote. SQL Server certainly supports inner joins.

Questions about posting. See faq183-874

 

[bjm027]

This is what I tried

------CODE--------
UPDATE tbl_1 INNER JOIN tbl_2 ON tbl_1.ID=tbl_2.ID
SET tbl_1.Company = tbl_2.Company;
-----------------

 

[SQLSister]

UPDATE titles
SET ytd_sales = titles.ytd_sales + sales.qty
FROM titles, sales
WHERE titles.title_id = sales.title_id

Questions about posting. See faq183-874

 

[bjm027]

Thanks for the help. Worked perfect.

 

[ESquared]

quote won't let you put spaces in the quotee name