Need to find the unmatched records in unrelated tables

[Kylor]

I have two tables of information on employees that are not related because they come from two different sources. I need to find which employees are not on both tables. I will need to also show which ones are on both tables. Thanks.

 

[Kylor]

full outer join

Sounds good. I'll try it when I get back into the office. Thanks so much!

 

[Kylor]

Select * from query1
Union Select * from query2;

Sorry, I tried perhaps I am missing a step? I am using the Soc # on both tables as the related field. When I tried your suggestion I ended up with 23 Million records. The original tables had 1100 and 2100.

I did the left and right join queries then used those the two in order to create a third. What do you mean by "union select"? Maybe that is what I am missing?

 

[Kylor]

Got It!

The third query (the only sample I posted) is supposed to be a union query.

This is where I went wrong. There was no relation between the tables in the third query. When joined the tables I got back 1049 records. Thanks.