Missing from one table

[Dale DeRemer]

We want to make a query where we check table A for employee numbers and
compare that with table B. We would like to build a list of employees who
are in table A but not in table B. An ideas on how to build that type of
query?

[Hans Forbrich]

Re: Missing from one table

Dale DeRemer wrote:

We want to make a query where we check table A for employee numbers and
compare that with table B. We would like to build a list of employees who
are in table A but not in table B. An ideas on how to build that type of
query?

Use the SELECT 'MINUS' capability. (SELECT ... MINUS SELECT ...)