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

file_put_contents and createimagefromjpeg
All,
I do somethings and then I have the following code:
file_put_contents('./test/'.$filename

Google Map
I have done Google Map Integration for one my project. But for that we need the "latitude and l

PHP and SMS
Hi all forum members. I am new here and am unsure what category shoild I post this in.
Moderator

Multiple arrays inside data
Hi,

Simple question. I have a column called "array" in my database, and inserted in

Oracle Connectivity
Hi Every One,

Can we access SAP from oracle database.If it possible then please spec

how do i display data on a page from mysql
1 - do i use this code at the top of each of my page i wish to only alow access if there as been a s

please help me in this update statment
hi every one

if I have table and this data in it

id name
10

Database connection failure
Hello All,

I am trying to create new connection to Oracle DB 10.1,
I could not see a

please help me in this update statment
hi every one

if I have table and this data in it

id name
10

PHP Game
hy i was wondering what's the best method in order to make some automatic updates in a php game
<