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 |
|
vernonmechery
Starting Member
1 Post |
 Posted - 2011-09-08 : 05:08:48
|
| Hi Folks,I have a table "temp". I want to write a query which will update the email address in "temp" to the "alt" table.There is a table "comm" which hold the id's and customerid's which acts as a mapping table for temp and alt.Let me know if I need to explain further.. |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-09-08 : 08:10:12
|
| [code]UPDATE aSET info_email = e.email_addressFROM email_temp_table eJOIN sp_comm_party sOn s.account_id = e.account_idJOIN alt_comm_point aOn a.cust_id = s.cust_id[/code]By the way, I won't prefix my table names with sp_ as that is what system stored procedures are prefixed with. |
 |
|
|
|
|
|
Sql statement