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 |
|
saidev
Posting Yak Master
101 Posts |
 Posted - 2006-07-20 : 17:12:09
|
| Hi Guys,I have two tables Book1 and Book2 Book1 Book2 sub1 sub5 sub2 sub6 sub3 sub7I need to update the book1 table columns based on book2 table columns. can you guys help me with SQL QueryThanks, |
|
|
tonymorell10
Yak Posting Veteran
90 Posts |
Posted - 2006-07-20 : 17:21:10
|
| To update book1 values from book2, something like:update book1set col1 = book2.col1from book2 where <join condition...>Is this what you're trying to accomplish? |
 |
|
|
|
|
|
SQL Update