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

Better Method of a Member Cloud
I assume most people know how tag clouds work, where the tags most used are bigger and the least use

DELETE FROM not working deletes wrong row
Hello

I have the following code which i found but it doesnt work properly.. it comes up with

Help with syntax
Hi all!

The $bridge variable is not getting passed while it is contained in the line below:

Generating unique numbers using php
Hi,
I need help in generating unique number using php.I tired using rand() in php.But, by using r

 formating when pulling data from a mysql database 
Ok so Im not to sure if this is the right thread to post in but here is my catch 22 issue.

I 
MySQL-PHP Query Results Help 
Hello all. I'm hoping to be able to get some help in solving a problem with query/rowcount output. I
Call Screen statement Error 
Dear Experts,



is there any setting that needs to be done before creating any dialog progr
Dealing with code in db query 
I am dealing with C code and I need to make sure it is encoded some how to ensure its integrity and 
Help with translating C code into assembler code 
Hi im doing a project that moves a robot around a maze avoiding walls and need some help with conver
What exactly is net neatrality? 
What exactly is it? I think it's anti-censorship and... stuff... but I don't really understand it