Joining two tables and then performing a query on result

[maloneyp]

I have imported two .DBF tables into Lotus Approach:

Employee table (contains employee number, name etc)
Ethics table (contains training records that contain employee number, type of training, the training date, etc)

I joined the two tables.

How do I do a query or a select on the two tables to:
1) Find out which employees have taken the training?
or
2) Find out which employees have not taken the train
ing?
You help is appreciated because I can't figure it out!
Thanks