Combining data from two columns

[kgkane]

Hi all again. I have another SQL Query question for you. I need to update a column in one table with data from two columns in another table. How would I go about this? Thanks again in advance for any help.


Kevin

 

[PHV]

Which RDBMS ? Which tables ? Which columns ? Which joins ?
What have you tried so far ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[kgkane]

OK Sorry. It's on MSSQL Server. basically what I need is this:
UPDATE Table1 Set Columname = Table2.Columname1 + Table2.Columname2
Hope this sheds a little more light on the subject.


Kevin

 

[JamesLean]

Something like:

UPDATE t1
SET c2 = t2.c2 + t2.c3
FROM t1 JOIN t2 ON t1.c1 = t2.c1

--James

 

[kgkane]

worked great thanks