I have two tables:
One contains a filtered list
The second contains the entire list
The EI (entire list) has 143,611 records
The FI (filtered list) contains 82,699 records
Both tables have only two fields in common, a dealer code and salesperson id.
The two fields combined make up the search criteria i would like to use.
I was thinking of just making a quick query to combine the first two columns on both tables to make things easier. But thought a concatenate function contained in the query code would accomplish the same thing.
Both tables can have more than one instance of DS
ex:
FI:
DS Location Phone Number Name Email
3A Canada 123-456-7890 John Doe JohnDoe@Nowhere.com
3A US 123-456-7890 John Doe JohnDoe@USANowhere.com
EI:
DS Sale Figure
3A 1,000
3A 2,000
3A 500
I would like to search the FI table against the EI table and for each instance that it found a match, insert all the columns attached to both tables for that particular record. So if a match is found, it would create three records in the new table.
I was thinking of solving it by making a select statement to search the records for the DS within the EI, then whenever found, return everything from both tables in that record to a new table.
I've looked through the forums and online, and the solutions i'm finding do not give me a defininative answer. Any help is appreciated, thanks, and i've been looking on these forums for my answers for a while, i really love all the help you guys/girls give. First time i've had to ask a question.
Noc
One contains a filtered list
The second contains the entire list
The EI (entire list) has 143,611 records
The FI (filtered list) contains 82,699 records
Both tables have only two fields in common, a dealer code and salesperson id.
The two fields combined make up the search criteria i would like to use.
I was thinking of just making a quick query to combine the first two columns on both tables to make things easier. But thought a concatenate function contained in the query code would accomplish the same thing.
Both tables can have more than one instance of DS
ex:
FI:
DS Location Phone Number Name Email
3A Canada 123-456-7890 John Doe JohnDoe@Nowhere.com
3A US 123-456-7890 John Doe JohnDoe@USANowhere.com
EI:
DS Sale Figure
3A 1,000
3A 2,000
3A 500
I would like to search the FI table against the EI table and for each instance that it found a match, insert all the columns attached to both tables for that particular record. So if a match is found, it would create three records in the new table.
I was thinking of solving it by making a select statement to search the records for the DS within the EI, then whenever found, return everything from both tables in that record to a new table.
I've looked through the forums and online, and the solutions i'm finding do not give me a defininative answer. Any help is appreciated, thanks, and i've been looking on these forums for my answers for a while, i really love all the help you guys/girls give. First time i've had to ask a question.
Noc
