|
hussainzim
Starting Member
21 Posts |
 Posted - 09/26/2007 : 09:29:08
|
Query(a report) to list the technicians/traffic controllers separately with following details.
EmployeeId,Name,Salary,Address,UnionId, and the most recent medical examination date for traffic controllers
Employee (EmployeeId(p),Name,Salary,Tpye).
MedicalExamination(MedicalNo(p),EmployeeId,MedicalDate)
EmployeeUnion(EmployeeId(p),UnionId(p))
"Type" field in Employee table tells whether its a technicians or a traffic controller.only traffic controllers has medical examination. |
|
SQL to list technicians and traffic controllers
