Attendance details for employee

Aug 30 2016 3:27 AM

I have two tables

1)tblEmployeeMaster

EmployeeCode EmployeeName

EMP001 Prakash

EMP002 yuvaraj

EMP003 siva

EMP004 nirmal

EMP005 sathya

EMP006 anand

2)tblTime

UserId TimeIn TimeDate

EMP001 10:30AM 30-08-2016

EMP002 10:10AM 30-08-2016

OutPut:::::

EmployeeCode EmployeeName Status

EMP001 Prakash Present

EMP002 Yuvaraj Present

EMP003 siva Absent

EMP004 nirmal Absent

EMP005 sathya Absent

EMP006 anand Absent

Please help me.....

Answers (2)