Can we form a inline view on the results of a previous query (another inline view)?
Ex:
select employees.emp_no,
employees.ename,
departments.dept_no
from
(select dept_no from dept) departments,
(select emp_no, ename from emp) employees
where employees.dept_no = departments.dept_no
In the above example, first the compiler forms 2 inline views employees and departments and then joins these 2 in the where clause.
But can we form the "employees" inline view to have only those rows based on the results of "departments" query.
Thanks