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

Losing 'page' data
I have this code that allows me to update my database. But after updating, I lose the $_GET['page']

 formating when pulling data from a mysql database 
Ok so Im not to sure if this is the right thread to post in but here is my catch 22 issue.

I 
Please help - should be a simple fix.. driving me nuts 
Everything seemed to be working fine.  I have a table, it alphabetically lists a bunch of cities and
cURL proxy 
Okay here is the thing...  i know how to add proxys

Code: curl_setopt($ch, CURLOPT_PROXYTYPE,
Not "Just Another" MMORPG - text based. 
Hello,

I've been learning MySQL and PHP for the last 2-3 years.
Though, I've had long paus
php forms and database navigatio 
Hello,
I'm new to php and i'd like to post the following.
I have written code to get records f
Disable html within defined tags 
I have a mysql database that allows users to enter content with html, but I also want to have a tag 
Php Mysql Page Loading Notice 
Hi all,

I was wondering if there is a way (Sure there is) of showing a message or an image wh
Customizing message/behavior 
Hi,I'm using the ASP.NET membership/authorization controls in my application. Some parts of my appli
Checking if variable is 0 as opposed to NULL/Empty... 
I'm trying to write some code that will retrieve a user's access level from my database and if it do