Comparing lists 1

[OpsO]

I have two querys that produce lists of employee numbers. One list is employees that have been trained and the other is just a list of all employees. I am trying to create a third query to return a list of employees that have not been trained. Any suggestions?

I didn't create a query simply asking which employees did not have the code for this specific training because each employee has multiple codes in the training table and I haven't figured out how to extract specific codes that are missing.

 

[OpsO]

I am using Congnos Report Studio

 

[blom0344]

Create a set from both queries. From query panel drag the except set operator to the right. In the query panel you will then see two placeholders for queries. Drag the existing queries (that will have to be identical in number of dataitems and datatypes) into these placeholders. These will then be presented as query references.
There will now be a third query that is the result of the except set operator like:

Select ....
from
(select .... from ....
except
(select .... from ....

The order of the queries is crucial the second set will be subtracted from the first set. So, if the first query contains all employees and the second query those who are trained than the except set operator will yield a list of employess NOT trained.

Ties Blom