I have 3 table like the following. I want to add a column (City) to TableA and then update data in this column from TableC
TableA
CustNumber FirstName LastName
A0001 John Doe
A0002 Richard Crena
A0004 Elvis Presley
TableB
CustID CustNumber CustType
1 A0001 A
2 A0002 B
3 A0004 C
TableC
CustNumber CustAddress CustCity
1 9002 Sunset Blvd Beverly Hills
2 20403 Inglewood Ave Inglewood
3 1158 PC Hwy Malibu
The end result should be
TableA
CustNumber FirstName LastName CustCity
A0001 John Doe Beverly Hills
A0002 Richard Crena Inglewood
A0004 Elvis Presley Malibu