I'm trying to update a table of phone numbers from another table
updating the phone # in table 1 if the field is not populated already.
I can get the code to work individually but not together.
Any thoughts?
example of the updates.
---------------------------------------------------------------
update1.
UPDATE dbo_Organization INNER JOIN Phone ON dbo_Organization.ExternalAccountID=Phone.Cust SET dbo_Organization.phone1 = Phone.phone1, dbo_Organization.PhoneType4GUID_FK = {guid {E9DE5F83-0BF0-7148-97E8-2F2FD7EB77AC}}
WHERE (dbo_Organization.ExternalAccountID=Phone.Cust) And (ISNull(dbo_Organization.phone1) Or dbo_Organization.phone1=' ');
-----------------------------------------------------------
update 2
UPDATE dbo_Organization INNER JOIN Phone ON dbo_Organization.ExternalAccountID=Phone.Cust SET dbo_Organization.phone4 = Phone.fax, dbo_Organization.PhoneType4GUID_FK = {guid {E9DE5F83-0BF0-7148-97E8-2F2FD7EB77AC}}
WHERE (dbo_Organization.ExternalAccountID=Phone.Cust) And (ISNull(dbo_Organization.phone4) Or dbo_Organization.phone4=' ');
---------------------------------------------------------------
Thanks.