Hi,
I have 2 tables "customers" and "cancel"
the cancel table comes from a third party.
Customers table has CustID CustName SignupDate CancelDate CancelReason
CancelTable has CustID CancelDate CancelReason RoomCode Promocode
As the Customers table is the original Table it contains no cancel info yet.
I would need to get the CancelDate and CancelReason info into the customers table but I can not figure out a way to do it.
UpdateQueries let me only put in 1 certain data but not the variety that is in my cancel table...
Sorry, but i'm not a database programmer and I do not have much resources...
I have 2 tables "customers" and "cancel"
the cancel table comes from a third party.
Customers table has CustID CustName SignupDate CancelDate CancelReason
CancelTable has CustID CancelDate CancelReason RoomCode Promocode
As the Customers table is the original Table it contains no cancel info yet.
I would need to get the CancelDate and CancelReason info into the customers table but I can not figure out a way to do it.
UpdateQueries let me only put in 1 certain data but not the variety that is in my cancel table...
Sorry, but i'm not a database programmer and I do not have much resources...