OK, I'm very new to SQL and sure could use a pointer. I am utterly
confused. A million thanks.
An abstraction of the problem I have follows:
Suppose I have two tables in my database. The first is just an employee
summary (Last Name, First Name, Employee ID, etc.). The Employee ID is
the primary key.
The second table is multiple rows but two columns, Employee ID and a 2
digit ( integer data type ) codes corresponding to course training
they've received. Conceivably each Employee ID may have as many as 24
rows as there are 24 different courses. Now I'm trying to develop a
query which allows me to identify employees who have completed (say)
course 1, AND course 2, AND course 10, AND course N ... etc. (you get
the idea).
I've played around with inner joins, subqueries to the point of
confusion. I can do this with OR logic but not with AND.
SELECT DISTINCTROW Employees.FirstName, Employees.MiddleInit,
Employees.LastName, Employees.DepartmentID, Tests.EmployeeID
FROM Employees INNER JOIN Tests ON Employees.EmployeeID =
Tests.EmployeeID;
?????WHERE?????????
Might someone point me in the right direction? Thanks a million,
