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

utl_file open error
i have file in the unix path

Path /popdev01/pop/popdevb/tfi/

File name

On page view, minus credit
Hello all, please, I need a little help with this script. I am charging one credit (credits can be p

Multithreading design
Hi

I have come up with a Singleton class that manages a pool of database connections. Basical

Validating time
Hi Guys

what do you think of the following approach to validate a 24hour time:

http://

Greek characters in php
Hi,

I'm making a script and I m using for first time greek characters.
I started to write

How can i steam a video on my PHP site? (non YouTube)
Basically I have a PHP site and don't want to give page rank to YouTube. I just want to stream a bas

To change the name of label on SAP screen XK02.
Hi All,

Can one suggest me how to change the label of an input field of a sap standard s

Add a sign-up feature to a flat file login script
I'm working on a flat file login script and I would like to add a sign-up feature to it with a email

Creating an invoice
Using fpdf I am trying to create an invoice to send to clients. The products are sold in pricing tie

Small problem with image resize script
Hi!

I am a little bit new to php and I have an issue installing an image resize script I down