Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Chap
Starting Member
30 Posts |
 Posted - 2010-02-04 : 16:02:15
|
| How do I update a column in a table from a column in another table? The update set = returns "Subquery returned more than 1 value......"There are multiple rows joining on id.George |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Chap
Starting Member
30 Posts |
Posted - 2010-02-09 : 13:52:26
|
| Thank you Tara, it seems so simple. I guess I was trying to make to much of it, you query worked great.ThanksGeorgeGeorge |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-02-09 : 13:55:43
|
| you need to make sure relation b/w Table1 & Table2 is 1 to 1 else it can result in random update |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Update Multiple Rows in Table