How To Get Employee Absent Report

not understand your query

+1

This is logic to find absentees in a day...Check if this helps you..

select emp_id,emp_name from emp_table where emp_id not in (select id from emp_in_out_table where punching_time >='2017-12-11 00:00:00' and punching_time < '2017-12-11 23:59:59'

+2

Laxmidhar Sahoo8y ago

pl send table structure

+1

Nilesh Yadav8y ago

Please mention All Information about Table Like Column Name, Table Name etc and Give Professional Report about Your Question.

+1

Nitin Sontakke8y ago

Is this an home-work assignment or a real life requirement.

If it is a real life requirement I suggest that you generate a professional quality report and not just a list with employee Id, name and absent dates.

Will you agree? If yes, please do let me know and we will take it from there.

+2

Altaf Ansari8y ago

Please try this :

Select Emp Id, Name, Date from Employee where InTime=null and OutTime=null;

+1