update a table with a column from another table

[jlt1]

Hi can anyone help me. I am using MS SQL 2000. In my database I have a table say table1 with three columns a, b and c. Columns a and b have 20 rows with data whilst c has 20 empty rows (with null data). I have a second table - table2 with a column c. How can I best update table1 so that data from column c in table 2 replaces the null rows in table1 column c (without appending additional rows.)
Many thanks from an sql novice.

 

[tlbroadbent]

Do the rows in the tables have related columns? Assuming columns a and b are related, the following example should help you get started.

Update Table1
Set c = table2.c
From Table1
Inner Join Table2
On Table1.a=Table2.a
And Table1.b=Table2.b Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.