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 |
|
rajesha
Starting Member
36 Posts |
 Posted - 2003-01-07 : 09:16:41
|
| i have 2 tables in table1 fields are sno,phonenum,namein table2 fields are sno and phonenumi want to update phonenum in table1 with phonenum in table2 curresponding to sno how can i write a single query to update phonenum in table1 by joins or anyother waycan anybody help me |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2003-01-07 : 09:21:23
|
| UPDATE T1SET PhoneNum=T2.PhoneNumFROM Table1 T1 INNER JOIN Table2 T2ON T1.SNO=T2.SNOEdited by - robvolk on 01/07/2003 09:21:47 |
 |
|
|
|
|
|
update by joining table