select empsal.empno as emp_no, empsal.salary as salary, empsal.lastname as last_name, empsal.firstname as first_name from ( select emp.emp_no as empno, sal.salary as salary, emp.last_name as lastname, emp.first_name as firstname from ...