T
TotallyConfused
I need help please with the following. I need to run an update query to
check if table 1 phone field has a phone listed if it is the same as table 2
then skip if table 1 phone field is empty and table 2 has a listed phone than
update with table 2 phone. If table 1 phone field is listed and table 2 has
no phone listed go to next. Does this make sense? How do I write the syntax
for this query? Thank you for any help you can provide.
check if table 1 phone field has a phone listed if it is the same as table 2
then skip if table 1 phone field is empty and table 2 has a listed phone than
update with table 2 phone. If table 1 phone field is listed and table 2 has
no phone listed go to next. Does this make sense? How do I write the syntax
for this query? Thank you for any help you can provide.