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

Hyperlink in PHP to MySQL record
Hello,

I am having trouble as i am new to php. I have connected to the database and I have di

close site for maintenance
i get a tutorial, saying the following code can put our site offline, and only the developer can vie

Anti Spam Code Problems
Ok where do i start? Probably by telling you I have very little working knowledge of PHP and that I

Secure pages Sessions vs. Cookies & session_destroy() help
Im new here and new to PHP, I hope you can help me with some questions.

Im writing my web ap

Custom CMS
This is a big custom CMS script I'd like to develop and would like some help atleast figuring out wh

Stumped by Third Day of Month problem
I am trying to build an algorithm that will essentially do this:
Code: [Select]$this_month = Oct

need help in creating captcha
hi i have a problem creating captcha system. i create some basic script for image displaying but it

sql problems
I am having a small problem with my sql statement. it is inserting into 4 of the fields.

fie

Cant display mysql data
Hey all,

I am learning php and my first goal is to create a simple CMS. At the moment I am st

session_destroy();
new to php
I have a simple login and am trying to write a logout.
I set a $_SESSION var to 1 i