J
jmaze
I have 2 tables I'm dealing with:
Training - employees' training (only has data when a course has been
completed)
Project - list of required courses an employee needs to be able to be
involved with the project
I need a query (or report) to show every course in "Project" and then I want
to see whether or not an employee has taken all the required courses. Right
now my query only shows me courses for an employee if they have a
corresponding date. I want to see null values for dates, too, but an "is
null" constraint yeilds nothing. Is there a way to get something like this?:
First Aid...John Doe...1/1/2008
CPR.........John Doe...
AED.........John Doe...1/1/2008
My Query SQL:
SELECT DISTINCT tblProject.course_number, tblProject.course_title,
tblTraining.employee_id, tblTraining.employee_name,
Max(tblTraining.completion_date) AS MaxOfcompletion_date
FROM tblProject LEFT JOIN tblTraining ON (tblProject.course_number =
tblTraining.course_number) AND (tblProject.course_title =
tblTraining.course_title)
GROUP BY tblProject.course_number, tblProject.course_title,
tblTraining.employee_id, tblTraining.employee_name;
Training - employees' training (only has data when a course has been
completed)
Project - list of required courses an employee needs to be able to be
involved with the project
I need a query (or report) to show every course in "Project" and then I want
to see whether or not an employee has taken all the required courses. Right
now my query only shows me courses for an employee if they have a
corresponding date. I want to see null values for dates, too, but an "is
null" constraint yeilds nothing. Is there a way to get something like this?:
First Aid...John Doe...1/1/2008
CPR.........John Doe...
AED.........John Doe...1/1/2008
My Query SQL:
SELECT DISTINCT tblProject.course_number, tblProject.course_title,
tblTraining.employee_id, tblTraining.employee_name,
Max(tblTraining.completion_date) AS MaxOfcompletion_date
FROM tblProject LEFT JOIN tblTraining ON (tblProject.course_number =
tblTraining.course_number) AND (tblProject.course_title =
tblTraining.course_title)
GROUP BY tblProject.course_number, tblProject.course_title,
tblTraining.employee_id, tblTraining.employee_name;