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

AUTONUMBER PROBLEM
Hello Everyone,

My name is Jones and i am new to this forum and to oracle. I am using ora

MS Access data into a html table
Hi everyone, I am quite a novice at php but I have created some helpful scripts that fetch data
f

php global variable
how can we create global variable so we can use its value in any form.. Please give example to

error reporting
hey everyone

I have a production server in which I want error reporting but only on some page

BackButton Behaviour in AJAX
I have an ASPX Page AJAX Enabled!The page has a gridView and a DDL for filtering on it. The Gridview

$variable $variables type question
I need to be able to designate an array element dynamically, so I thought to use a variable variable

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

IF Statement & Two Tables With Different Echoes
I'm retrieving two tables in a single query using UNION ALL, like so:

Code: $query = "SE

Firewall / visited websites logger
Hi. I have a firewall implementation and I want to log all the websites visited on the machine. S

getting most records by count
Code: [Select]<?php

$connect = mysql_connect("localhost","dam