I have the following informations and i want to generate an attendance report per day.I will explain the concept

 

EMP Table

 

ID   NAME 

 

1     Hassan

2     Hussain

3     Hameed

4     Cruz

5     Philip

 

Transaction table

EmpID     Time

 

1             5/8/2010 8:00 AM

2             5/8/2010 9:00 AM

3             5/8/2010 10:00 AM

 

My Attendance Report should look like this

 

Date:5/8/2010

 

ID  NAME      STATUS

1     Hassan   Present

2     Hussain  Present

3     Hameed  Present

4     Cruz       Absent

5     Philip      Absent

 

How to achieve this.Any help asap is appreciated.

Thank u..

 

But the report displays only those employees, having transactions on that day.That means,the left outer join didn't work.

The report look like this,

 

ID NAME  StATUS

1   Hassan    Present

2   Hussain   Present

3   Hammed  Present

 

Thanks in advance for any help/advice you can give.