*preface, I am a newbie (this should be easy)
I want to migrate my customer information from one table to another table.
The table in called Customers, the other is called CustomersOLD.
They have different column names, like lname and LastName.
I want to get all the data from CustomersOLD into the Customers table.
How do move the data from one table to the other. I plan on deleting the CustomersOLD table. (or not use it).
Thank you kindly.