I'm working on a training tracker program and I'm at a point where I cant figure out the SQL query.
I have 3 tables: employees, trainingRecords, masterList
.
employees
and trainingRecords
are related through the empID
fkey.
trainingRecords
and masterList
are related through the TID
fkey.
Right now the training records table is blank because nothing has been entered (all employees have no training).
I want to populate a listbox with all of the items in the masterList that are unaccounted for in the trainingRecords
table.
Since the trainingRecords
table is blank, it should be returning lName, fName
from the employees
table and docName, docNumber
for all entries in the master list.
Im stumped. Any suggestions?