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

Email logic not working
I would like to send an email using the php email() function then if it does execute i.e sends i wou

Loops and Classes
I am making a template system and everything seems to be going well up until I have to loop in a var

displaying unknown amount of results
I am reading a directory and getting a list of folders in the directory, I want to display the folde

Feed Maker
Hi all.
First of all I must say I am not a php developer so I am afraid I don't know much about i

GIS appliction help
I found some tutorials in the internet to develop a map application I don't want to use google maps

search function
HI guys,

if anyone could point us in the right direction of how to do this, or provide some t

upload image name with extension using php
hi frds..

<input id="file1" type="file" name="file[]" &a

mail with attachment problems
Hi. I have the following code:
Code: else if(file_exists("site".$timp.".zip")

Form submissing with PHP and JQuery/Ajax
I have searched everywhere, but cannot find a solution for this... I have worked all day trying to g

Remove values in array2 from array1
I have two arrays.

Array 1 is where the array key holds various different numbers. For exampl