So i need to have a query to show any customers details that have changed in a master table v a local table
Cus_ID
Phone_1
Phone_2
Email
I have the same fields in both tables i need to have the query look at Master Table (Customer_Master) and Bring Back any records that do not match the Local Table (Orders) data, I will then use this query to make an update query to bring the Local Table upto date?
is this possible
Cus_ID
Phone_1
Phone_2
I have the same fields in both tables i need to have the query look at Master Table (Customer_Master) and Bring Back any records that do not match the Local Table (Orders) data, I will then use this query to make an update query to bring the Local Table upto date?
is this possible