Hi Good day!
I have 2 tables for my dtr database.
first the employees where all the data of employee was save.
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').