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

Count
Getting the same count everytime

Code:
$visitquery = mysql_query("SELECT COUNT(*) FR

Strange PHP/mySQL error ... am I just tired?
Code: <?

## CONNECT TO DB FUNCTION!
function ConnectTo($db2con)
{
$hostNam

How to clone an SAP ECC using bacup tape on z/os?
We want to clone our production to a different SID using backup tape.

Check premium expire
Hi,

I am making a simple file hosting site and want to check if users premium subscriptions h

Logic question
im wondering what's the best method to do the above list:

it is for alliance @ MMORPG game

get the country of visitor and display content based on that
Hello all,

I have seen that Google analytics can tell you where a visitor is coming from and

[newb] Image hosting help.
Hey there, I'm new to php, I know some basics and i can code PWN, I'm only 14 but I'm interested in

php form help
Hey,

I use a control file to set my meta tags and titles

Here's an example
Code: &a

'grab_files', multiple extension?
hey guys,

can anyone suggest a way to make to following line of code look for files with more

MySQL query problem
When I try to run the following piece of code, I get this error:
QuoteWarning: mysql_query(): sup