Hi Good day!

I have 2 tables for my dtr database.

first the employees where all the data of employee was save.

employees fields:

EmployeeID
Lastname
Firstname
Sub
Department


attendance_log
EMP_ID
LOG_TIME (datetime)
INDICATOR

I tried lots of query to get the EmployeeID where no attendance on the date I want to check who are the absentee.


I just want to select the EmployeeId where no LOG_TIME with the date 2013-05-02

attendance_log table is the table where the time in and out was save.

I hope somebody can help me to get only the EmployeeId with no attendance where Sub = 'REG' and Department IN ('QA', 'Engineering', 'Assembly').

Thank you