September 2nd, 2003, 11:58 PM
|
 |
Banned ;)
|
|
Join Date: Nov 2001
Location: Woodland Hills, Los Angeles County, California, USA
|
|
Something like this perhaps:
Code:
UPDATE ca
SET ca.first_name = ci.first_name,
ca.last_name = ci.last_name,
ca.address = ci.address,
ca.city = ci.city,
ca.state = ci.state,
ca.zip = ci.zip
FROM custAddress AS ca
INNER JOIN corrected_info AS ci
ON ca.recordNum = ci.recordNum
DISCLAIMER: I have not actually tested the above statement. Back up your data before trying it out. Hope this helps 
__________________
Up the Irons
What Would Jimi Do? Smash amps. Burn guitar. Take the groupies home.
"Death Before Dishonour, my Friends!!" - Bruce D ickinson, Iron Maiden Aug 20, 2005 @ OzzFest
Down with Sharon Osbourne
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
sql riddle
Linear Mode
