After many days of frustration, I had an epiphany. There was no common "denominator" in the tables. The only thing common was that each one had operator info. So. Created a query to perform a VLOOKUP-esque function on one of the tables to convert the operator information into the exact same format as the other table, created a query based on that query and another query based on the original table, and then a SQL union query that pulled info from both.

Thank you very much for your replies, insight and assistance.



This issue is resolved.