I have a customers (actually companies) TABLE which has one customer order per row and also the customer details in columns like ID, Address, Name (unique names) etc. BUT, there is no phone number column. The phone numbers are stored in a csv file, along with the corresponding ID.
I want to make a csv file which will have select columns from customers TABLE and also a new column for phone numbers. Please suggest some ways to do this.
Is it advisable to lookup the csv file to put the right phone numbers for a customer ? If yes, how to do it ?