Absent Report

zrtv · February 26th, 2008, 10:39 AM

Basically I had employee data with me in one table and their attendance information in another table. The task was to list out employees that were absent ...

How i can perform a sql Query

My Employee Table have
empID,empName,address,joinDate

And my Attendance Table have
empID,atDate(attendance Date),timeIn,timeOut

Can you tell me using these field how i can fetch the absent employee details...

BrianWren · February 26th, 2008, 02:33 PM

Code:

SELECT empID, empName, address, joinDate
FROM   EMPLOYEE
WHERE  EMPID NOT IN (SELECT EMPID
                     FROM   ATTENDANCE);

zrtv · February 27th, 2008, 04:08 AM

Thanks Mr. Brian
Its work fine