Form a inline view based on the results of the previous query?

Posted on 16th Feb 2014 07:03 pm by admin

Hi Experts,
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

Your Answer:

Login to answer

Other forums

$variable $variables type question
I need to be able to designate an array element dynamically, so I thought to use a variable variable

weird problem
last time, i did post a topic concerning why my page sometime will load as blank page when using IE.

check if value exists
I have googled this for a while and I am getting lots of different results. Is there a standard meth

Problem with array max size.
Hi to everyone,
I've got a homework about filling a bidimensional array un spiral shape, I alre

Display last record first.
I need some help how put the last record first and first record last.

Thanks

Code: &am

Help with search.php
Hello All

I need the search engine on a site I am building at the moment to display the searc

need good snippet manager
Hi. as i am coding and learning more, it is becoming difficult to manage code snippets. how you mana

Storing user data help?
Hey Guys,

I'm not use if this question is to broad but I can always give you more informatio

Error with login script
I am getting an error with my login script:

Error:
Code: Warning: Cannot modify header inf

Functions Not Loading Into Div
I had some help doing some of this but what I'm trying to do is get my functions to retrieve its val