Creating a new Dynamic Table dependant on 2 tables

[Ron_Mowry]

I have 2 tables Employee list and March Connected . The Employee list table has all the employees and managers from my my local department and the March Connected table has a list of all completed saled from my local department and sales that are completed by agents at another location but without a manager listed. Now what I would like to do is take all the employees that are listed in the Employee list along with their manager and combined that with the agents who are listed in the March Connected table who are not listed in the Employee list. I would manually enter the employees who are not local if I had a list of all the employees in other locations but I do not have this data since these type of sales are completely random. If I can get this done with will make all future queries easy for me.

 

[Dennisk]

use a DISTINCT union query, This will give you a list of all the unique rows

SELECT * FROM [Employee List]

UNION
SELECT * FROM [March Connected]