SQL & PL/SQL

select department_id, last_name, job_title
from employees, jobs
where department_id=60
OR department_id=90
Order by department_id, last_name DESC;


OUTPUT:
DEPARTMENT_ID LAST_NAME JOB_TITLE
------------- ------------------------- -----------------------------------
60 Lorentz President
60 Lorentz Administration Vice President
60 Lorentz Administration Assistant
60 Lorentz Accounting Manager
60 Lorentz Public Accountant
60 Lorentz Marketing Representative
60 Lorentz Sales Representative
60 Lorentz Stock Manager
60 Lorentz Stock Clerk
60 Lorentz Programmer
60 Lorentz Marketing Manager

DEPARTMENT_ID LAST_NAME JOB_TITLE
------------- ------------------------- -----------------------------------
60 Lorentz Sales Manager
60 Hunold President
60 Hunold Administration Vice President
60 Hunold Administration Assistant
60 Hunold Accounting Manager
60 Hunold Public Accountant
60 Hunold Sales Manager
60 Hunold Sales Representative
60 Hunold Stock Manager
60 Hunold Stock Clerk
60 Hunold Programmer

DEPARTMENT_ID LAST_NAME JOB_TITLE
------------- ------------------------- -----------------------------------
60 Hunold Marketing Manager
60 Hunold Marketing Representative
60 Ernst President
60 Ernst Administration Vice President
60 Ernst Sales Manager
60 Ernst Programmer
60 Ernst Stock Manager
60 Ernst Marketing Manager
60 Ernst Public Accountant
60 Ernst Administration Assistant
60 Ernst Stock Clerk

DEPARTMENT_ID LAST_NAME JOB_TITLE
------------- ------------------------- -----------------------------------
60 Ernst Sales Representative
60 Ernst Accounting Manager
60 Ernst Marketing Representative
90 Kochhar Sales Manager
90 Kochhar Public Accountant
90 Kochhar Programmer
90 Kochhar Accounting Manager
90 Kochhar President
90 Kochhar Administration Assistant
90 Kochhar Marketing Representative
90 Kochhar Marketing Manager

DEPARTMENT_ID LAST_NAME JOB_TITLE
------------- ------------------------- -----------------------------------
90 Kochhar Sales Representative
90 Kochhar Stock Clerk
90 Kochhar Stock Manager
90 Kochhar Administration Vice President
90 King Stock Manager
90 King Sales Representative
90 King Sales Manager
90 King Public Accountant
90 King Accounting Manager
90 King Administration Assistant
90 King Administration Vice President

DEPARTMENT_ID LAST_NAME JOB_TITLE
------------- ------------------------- -----------------------------------
90 King President
90 King Marketing Representative
90 King Marketing Manager
90 King Programmer
90 King Stock Clerk
90 De Haan Public Accountant
90 De Haan President
90 De Haan Accounting Manager
90 De Haan Programmer
90 De Haan Administration Assistant
90 De Haan Stock Manager

DEPARTMENT_ID LAST_NAME JOB_TITLE
------------- ------------------------- -----------------------------------
90 De Haan Administration Vice President
90 De Haan Stock Clerk
90 De Haan Sales Manager
90 De Haan Marketing Manager
90 De Haan Sales Representative
90 De Haan Marketing Representative

72 rows selected.