SQL to list technicians and traffic controllers

Question

SQL to list technicians and traffic controllers

zim-496632

SSC Enthusiast

Points: 186
More actions
September 26, 2007 at 7:28 am

#178081

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.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

Andras Belokosztolszki SSC-Insane Points: 22031 More actions · Answer 1

zim (9/26/2007)
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.

Is this a homework assignment?

I'd suggest having a look at the Join statements (http://msdn2.microsoft.com/en-us/library/ms191517.aspx) and the MAX function (http://technet.microsoft.com/en-us/library/ms187751.aspx)

Regards,

Andras

Andras Belokosztolszki, MCPD, PhD
GoldenGate Software

Lowell SSC Guru Points: 323518 More actions · Answer 2

show us the query you have done so far, so we can offer suggestions with your homework; you won't learn if someone just gives you the answer.

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!