ds_SnowSports
query
RESULTSET
query
  CELLPHONE EMAIL EMPID EMPSTATUS FNAME HIREDATE HOMEPHONE LNAME MNAME NICKNAME PRIMECERTNAME PRIMEDIS PSIAAASICURRENT SECONDCERTNAME SECONDDIS
1 777-777-4444 [empty string] 0 PT 30 bob 2024-01-10 00:00:00.0 [empty string] smith [empty string] [empty string] Level 2 Snowboard 1 Level 2 Telemark
2 [empty string] [empty string] 1 PT 16 steve [empty string] [empty string] sams [empty string] [empty string] Level 3 Alpine 0 Level 3 [empty string]
3 [empty string] [empty string] 2 Flex 12 larry [empty string] [empty string] toms [empty string] [empty string] [empty string] Telemark 1 Level 1 Adaptive
CACHED false
EXECUTIONTIME 16
SQL SELECT employee.empId, employee.fName, employee.mName, employee.lName, employee.nickName, employee.email, employee.cellphone, employee.homePhone, employee.hireDate, employee.psiaAasiCurrent, cert.certName as primeCertName, disipline.disipline as primeDis, employeeStatus.empStatus, c.certName as secondCertName, d.disipline as secondDis FROM employee left join cert on employee.primaryDisCertID = cert.certId left join disipline on employee.primaryDisiplineID = disipline.disID left join employeeStatus on employee.empStatusID = employeeStatus.empStatusID left join cert as c on employee.secondaryDisCertID = c.certID left join disipline as d on employee.secondaryDisiplineID =d.disID
NAME STATUSCELL PHONE HOME PHONE EMAILPRIMARY CERTSECONDARY CERTPSIA CURRENT
bob  smithPT 30777-777-4444 Snowboard Level 2Telemark Level 21
steve  samsPT 16 Alpine Level 3 Level 30
larry   tomsFlex 12 Telemark Adaptive Level 11