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

help with image text
Hi ...

see i need the text of the name and number to start in the center and always be in the

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

problem when runing a funciton
I am trying to connect to database using a funciton in a functions.php

<?php
funct

ORA-00932: inconsistent datatypes: expected - got CLOB
SO : windows xp
database : XE

there is a table (transito) with two fields of clob

Modal Popup Help
Hi guys, I have a modal popup with an iframe. How can i send data from a label or textbox to the ifr

Convert .fdf to .pdf
I currently have a web form that uploads the form data to an .fdf file and emails it.

However

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

ALV sum various columns problem
Hi all,
I'm doing a report on ABAP for a timesheet of the current month. The output i want is s

Request-URI Too Large
I have created a simple submit form for a mysql database that puts a piece of code into database.<

How to add an image/C++ OpenGL?
Hi,

I have been trying to look online for this and, so far, I haven't found anything usef