Hello,
I appreciate your time and effort. I have 2 tables;
1. Sponsors table about 50 records
2. Contractor table about 3000 records. Each contractor has a parent sponsor
I would like to query specific contractors field for each sponsor I can use the sponsor name as the criteria and run it 50 times but that's time consuming. Do you know of any other way to do this? Pretty much for every unique ID in the sponsors table create a separate table with the selected contractors information.
THANKS for your help