I need to update a bunch of shipping phone numbers. Basically I have a lot of shipping phone numbers that came into my system via WSI as blank. My old system didnt require shipping phone but ASPDNSF does and I have had a lot of customers confused by it. To get around this short term I updated all blank phone numbers to 999-999-9999
Id like a query that I could run that would update all shipping phones with 999-999-9999 set to that of the associated billing phone number.
something like
update address set phone = (select phone from address where ????) where phone = '999-999-9999'
Obviously what I wrote wont work but it gives the gist.
Any ideas?