- Ch11p4 Produce A List Of Jobs For Departments 30 50 And 10 In That Order Display The Job Id And Department Id By Us 1 (90.39 KiB) Viewed 36 times
Ch11p4: Produce a list of jobs for departments 30, 50, and 10, in that order. Display the job ID and department ID by us
-
answerhappygod
- Site Admin
- Posts: 899604
- Joined: Mon Aug 02, 2021 8:13 am
Ch11p4: Produce a list of jobs for departments 30, 50, and 10, in that order. Display the job ID and department ID by us
Ch11p4: Produce a list of jobs for departments 30, 50, and 10, in that order. Display the job ID and department ID by using UNION ALL. JOB ID DEPARTMENT_ID 1 PU MAN 30 2 PU CLERK 30 3 SH CLERK 50 4 ST MAN 50 5 ST CLERK 50 6 AD ASST 10
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!