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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-11-29 : 08:13:24
|
| Jagadeesh writes "I have tables called "A" and "B" ,there is no relationship between to tables,i just wants to update values in table "B" by using values in table "A"." |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-11-29 : 08:39:27
|
| How are you supposed to do that, when there are no relationship between the two tables?Peter LarssonHelsingborg, Sweden |
 |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2006-11-29 : 08:46:13
|
What is this? a circus?Be sensible in what you ask!update xset b = afrom table1 cross join table2 b  Harsh AthalyeIndia."Nothing is Impossible" |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2006-11-29 : 09:28:09
|
quote:
Originally posted by AskSQLTeam
Jagadeesh writes "I have tables called "A" and "B" ,there is no relationship between to tables,i just wants to update values in table "B" by using values in table "A"."
You cant. If you meant appending dataInsert into B(cols)Select cols from AMadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
Re:Update