Joined Tables (1 Viewer)

[gisash1]

I have two tables with salesmen. Some of the salesmen are in both tables. I need to creat the third table which will include the salesmen from the second table who aren't in the first table. In the Join Properties all criterias with "are equal" statement. But I need "are not equal".
Thanks in advance

 

[gisash1]

Actually all I need to do is to creat a list of salesmen from two tables, without duplicates.

 

[pbaldy]

A union query will do it:

SELECT Salesman
FROM Table1
UNION
SELECT Salesman
FROM Table2;

 

[gisash1]

....Thank-you.......