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 |
|
Maharisi
Starting Member
19 Posts |
 Posted - 2007-07-09 : 06:01:05
|
| I have two tables.First one.ID, NUMBER1 , 112 , 123 , 13Second one.OS_ID, 12 ,12 ,11 ,13 ,I need UPDATE SECOND TABLE attribute OS_ID to ID according to NUMBER Second table should looks likeOS_ID2,2,1,3,Thanks |
|
|
chiragkhabaria
Master Smack Fu Yak Hacker
1907 Posts |
Posted - 2007-07-09 : 06:17:28
|
| Update T2 Set Os_ID = T1.ID From Table1 T1 Inner Join Table2 T2On T1.Number = T2.OS_IDChiraghttp://www.chirikworld.com |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2007-07-09 : 09:41:34
|
| Do you need to really update that table?If it is for display you can simply select using JOINMadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
UPDATE Records