File #1 contains the following columns: unique id, name, address, etc.
File #2 contains columns with the unique id number (which corresponds to the id number that is included with the first file) and a voter history.
I need to match up the voter history with the name and address. The voter history file does not contain the name, etc. so the only way to match the two is the id number.
There are approx 11,500 rows in file #1 and 65,000 rows in file #2. File #2 has more rows because an id number may appear more than once depending on number of elections that were voted in.
File #1 sample data
FL00000408, First Name, Last Name, Address
1987533, First Name, Last Name, Address
File #2 sample data
FL00000416, 4/10/02, LANESBORO SPECIAL ELECTION
5758973, 11/3/98, State General
5758973, 11/5/96, State General
5765250, 11/4/97, School Board Election
5765250, 4/23/02, ISD #239 RUSHFORD-PETERSON BOND
I need to combine the voter history information with the name address information.
Hopefully this information will help clarify the problem.