Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
hussainzim
Starting Member
21 Posts |
 Posted - 2007-09-26 : 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 controllersEmployee (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. |
|
|
Kristen
Test
22859 Posts |
Posted - 2007-09-26 : 09:38:11
|
| See: http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=55210&SearchTerms=Homework |
 |
|
|
|
|
|
SQL to list technicians and traffic controllers