Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.
SELECT e.FirstName, e.LastName, e.LocationID, e.EmailAddress, (SELECT a.PhoneNumber FROM EMP_OWNER.EMP_PhoneNumbers a WHERE a.EmployeeID = e.EmployeeID AND a.PhoneTypeID = 5 AND a.EmergencyNotificationSystem = 'Y') AS HomePhone, (SELECT b.PhoneNumber FROM EMP_OWNER.EMP_PhoneNumbers b WHERE b.EmployeeID = e.EmployeeID AND b.PhoneTypeID = 6 AND b.EmergencyNotificationSystem = 'Y') AS MobilePhone, (SELECT c.PhoneNumber FROM EMP_OWNER.EMP_PhoneNumbers c WHERE c.EmployeeID = e.EmployeeID AND c.PhoneTypeID = 4 AND c.EmergencyNotificationSystem = 'Y') AS BusinessMobilePhone FROM EMP_OWNER.EMP_Employee e LEFT JOIN EMP_OWNER.EMP_PhoneNumbers p ON p.EmployeeID = e.EmployeeID WHERE TerminationDate IS NULL ORDER BY LastName, FirstName
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|Database Design Dilemma||6||71|
|setting local variables in a cursor block||3||41|
|How to manipulate two or more composite data type into single results set in oracle||4||58|
|Shared Service Environment||2||53|
Join the community of 500,000 technology professionals and ask your questions.