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

square instead of number
Hello
I do not know why but this code seems to work fine only in my xampp local insallation but n

Preg_match unknown modifyer
Hello,

Im trying to write a little script for my forums i need to get the reply from my forum

Interpret Order
Hello all,

I'm wondering if I have this:

Code: $switch = array(
'one' =>

Rand() help needed
Hi all,

Can someone explain and give me a quick example of how I would go about this?

Output Full URL of Current Page
Let's say I am currently viewing a dynamic page:

http://www.mydomain.com/directory/index.php

Login Control?!
I have a Web Site that uses the login control also I have set the destinationurl to the page I want

php code to accept and delete incoming data
Using following HTML Code please show me how to write PHP code to accept and delete the incoming dat

Are sessions secure at all?..
I haven't really gotten into yet, but I was just thinking of something weird..

Lets say you h

extract a file from zip file
hi,
i know how to unzip a zip file in php, but is there a way to just extract a certain file only

Syntax error
hi im having a little trobble with this script
-------------------------------------------------