OutPut of quries1 = Input into Quries2

[edisonl]

Hi everyone,

Background:
Am developing leave application. Supervisor login> System able to detect any leave awaiting for approval.

My Solution:
- Search by supervisor dept> list out lists of names (this lists are not captured in any particular controls just using normal quries Eg: SELECT blah blah blah.. By blah blah blah... )
- Once having a lists I used this lists of UserID & compared with another table (PendingLeave_Table) to check if their userid exists. If Have activate my controls/ prompt for supervisor approval accordingly.


Questions:
1. Any Ideas what other solution besides mine provides similar results ?
2. Is Union or what other types of quries is appropriate ?

Regards & God Bless, Edison Ler

 

[edisonl]

Hi, (Thanks for your reading & reply firstly)

1. Basically Output of qury1 generate lists of names & userid with same department.
2. From the department & userid, lookup another table & check if this names/userid exists.

Table1- Personne_table (Entails>> UserId, Dept, DateOfEmployment, Gender, Names, Nationality,AccessRights)

Table2- LeavePending_Table (Entails>> UserID & Type of Leave)

Functions:
1. Supervisor of Particular Department (Eg: Accounts Login)

2. From Supervisor ID (Eg: 099) System detect its from Accounts Department.

3. System able to prompt Supervisor if any pending leave requires His/Her Approval & Prompt accordingly if it does.

4. Therefore in order to do so DB should be able to retrieve lists of userid from Accounts Department & Lookup PendingLeave_Table. If UserID exists, trigger a prompt to Supervisor whenthey login into Leave Application.


Regards & God Bless, Edison Ler