How to query two tables and compare the results

[TEOA]

Hi,
I have conducted several searches but none of the results seem to be able to answer my query, now im sure it's going to be down to my lack of understanding so appologies if the answer has been staring me in the face!

I am putting together a database for work, I have a table that is used to refer to (this table is part of our production system) in this table it lists products run, dates run and who has run.

I have the training records data table, this lists; who, machine and status: "trained" "refresh required" " not trained"

I want to build a query so that it seaches the production table for the last 6 months worth of records & if an operator that is in the training table (WHO) as status (trained) is not in the production table it outputs a "to be refreshed" report or ammends the records from trained to "refresh required"


Im hoping its a simple problem.....
Many thanks

 

[plog]

Post table and field names from all relevant sources, sample data for all and then what this query should produce based on that sample data. Use this format:

TableName
Field1Name, Field2Name, Field3Name
17, John, 4/1/2013
16, Steve, 4/4/2013
42, John, 3/31/2013