how can i display data as i'm making a attendence report of employee for month
format is
EmpId EmplName datestatusreason
1ABC11/03/2012 P-
1ABC12/03/2012ANO INFORMATION
1ABC13/03/2012WWEEKEND HOLIDAY
1ABC14/03/2012LSICK
HERE I HAVE SOME TABLES
1 - EMPLOYEE RECORD
FIELD ARE -
EmpIdEmpNameweekndId
Emp1abcwo1
2- Weekendtable
weekndIdweekndName
wo1Sunday
3- AttendenceRecord
EmpIdDate
Emp101/03/2012
4-LeaveRecord
EmpIdStartDateEndDate
Emp114/03/2012SICK
hhow can i do this and i'm not using any procedure for this only use vb.net coding and sql query