Example
select department_id,
(select first_name from employees where employee_id=10) as “First Name”,
(select last_name from employees where employee_id=20) as “Last Name”,
(select department_name from departments where department_id = 20) as “Department”
from employees where department_id = 20;