fboehlandt
Registered User.
- Local time
- Today, 04:22
- Joined
- Sep 5, 2008
- Messages
- 90
Hi everyone
I am trying to complement data from one table with data from another.
Table 1
[Key][Customer_Name][Address][Phone_Number]
Table 2
[Key][Customer_Name][Address][Phone_Number]
I would like to update the details (Address, Phone Number) in Table 1 using the data in Table 2. However, the data in Table 1 should only be overwritten if there is data in Table 2.
I am sure this is pretty straight-forward but any pointers would be appreciated.
I am trying to complement data from one table with data from another.
Table 1
[Key][Customer_Name][Address][Phone_Number]
Table 2
[Key][Customer_Name][Address][Phone_Number]
I would like to update the details (Address, Phone Number) in Table 1 using the data in Table 2. However, the data in Table 1 should only be overwritten if there is data in Table 2.
I am sure this is pretty straight-forward but any pointers would be appreciated.