Hi, I need to make a "flat file" from two database table. The attached files show a simple two table database. Both tables are related by the "phone" column. The "master-addresses-and-phon
es.xls" file is a list of phone numbers and addresses. The phone number in this table is the primary key. The "master-name-and-phones.xl
s" file list of names and phone numbers. the "query-results.xls" file is the desired result.
Basicly, I need to put all the people's names in the same row with the correct address/phone related by the phone number. Some relations can have one name and other could have 8-10.
I am working in MS Access, but could set this up in MSSQL 2005 as well. Thanks for any tips.