MySQL Forums
Forum List  »  General

need help! query to get absentees list
Posted by: Dileep Kumar Ravuri
Date: November 15, 2010 01:35AM

I am working on BIRT Reporting tool, I have 4 tables as EMP_ATTENDANCE, EMP_APPLY_LEAVE, EMP_EXCEPTION_DETAILS and EMPLOYEE.

The Employee Table is linked with all the remaining tables.

EMPLOYEE
--------------------------------------------------------------------------------------
ID | EMP_NAME | EMP_APPLY_LEAVE_ID | EMP_ATTENDANCE_ID |
------------------------------------------------------------------------------------------
EMP_EXCEPTION_DETAILS_ID |.....
--------------------------------------
This is Employee Table I have.


EMP_ATTENDANCE
------------------------------------------
ID | DATE |.......
---------------------------------------
This is Attendance Table I have.


EMP_APPLY_LEAVE_DATE
----------------------------------
ID | FROM_DATE | TO_DATE |......
-----------------------------------------
This is Apply leave table I have.

Like the above table Exception details table I have. having the columns ID, START_DATE, END_DATE.


By using the above Tables. I want to get the absentees list.

Absentees means ---> all the Employees list, NOT in attendance table,NOT in apply leave table, NOT in exception details table.

MY I/P are----> Staet Date , End Date

whether I give two Dates like 15/11/2010 and 16/10/2010

I should get all the Employees list, those are not attended between these dates, not applied leave between these two dates and those not having exception details between these two dates.

That means
----> attendance date not between our I/P
----> apply leave from_date, to_date not between these I/P
----> Exception start_date, end_date not between these I/P


This requirement on BIRT Reporting.

Can any one Please HELP me to get this.



regards,
-------------------
Dileep Kumar.
dil.ravurimca@gmail.com

Options: ReplyQuote


Subject
Written By
Posted
need help! query to get absentees list
November 15, 2010 01:35AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.