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

article site help remaining text
Hi all hope you will be fine
I am creating a article site in this site i want to put some text on

Do While statement
hi guys,

This may sound trivial but im new to php and as part of an assignmenti have to const

multipart emiail forms
Hi All,

I am new to the boards and I've been working on a form (which is rather massive, imo

help with variable
I've got a problem, i want to echo some images depending on the $id, however for me to get that id i

filesize problem
i use ubuntu 9.10 and i have mountet a folder from an windows

/mount/FOLDER
/mount/FOLDER/

Load file in PHP
I have 2 files. The first is a PHP generated XML file that's dependent by 2 inputs. The second is a

Convert Binary String to Decimal
Trying to Get:
Decimal: 305419896

Out of:
Binary String: xV4

Number Format
Hi All,

I have number '000000000050085' I want to format it to 500.85 Can any one give me

Downloading file (Headers)
I'm trying to make users download a file, but they must wait 60 seconds before it begins.

But

php multiple action on submit
I have a form which says:

<form enctype='multipart/form-data' method='post' action='pr