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 |
|
ballabhoks
Starting Member
18 Posts |
 Posted - 2005-04-12 : 23:39:29
|
| Dear all,Data in my table looks as followsname address phone phone1 recidabcd 232a Okhla 1234 1abcd 232a Okhla 12345 2abc 23a Okhla 1234 3abc 23a Okhla 1234 4abc 23a Okhla 1234 5I want to update phone1 with the value of phone where value of name and address is same.Thanks,Ballabh |
|
|
rrb
SQLTeam Poet Laureate
1479 Posts |
Posted - 2005-04-12 : 23:40:56
|
[code]update tableset phone1 = phonewhere name = address[/code] but I don't think that's what you really want - maybe you could provide an example output also...--I hope that when I die someone will say of me "That guy sure owed me a lot of money" |
 |
|
|
|
|
|
Updating records