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

PHP form help required
Hi all! Apologies in advance for having to message the forum for help. I know you must get a lot of

form help
this doesn't work. i want the form action to go the location.href of the submit button chosen.. how

Including calander to page - will not show other months than current??
im trying to add an existaing calander onto a profile page by using Code: <?php include "

"From field" in PHP email form
I used a wizard to create a PHP email form. I was able to customize it with the exception of the Fr

Changing files over
Just thought I'd start with the new forums looking really nice .

Ok basically I've made this

Form Help
Here is the form:

Line number On/Off | Expand/Contract<? include("../include/sess

Protecting forms
Alright, I want to protect some forms of mine from SQL Injections, because I had someone earlier spa

Multiple if statements
Ok so seems basic but for some reason I'm not doing it right. What I want is to be able to have 2 se

Regular expression tips or resources
Hello! I'm having some issues implementing the appropriate regex patter to eliminate unwanted charac

Problem in String replace program's output
Hi all,
I was trying to make a program which accepts a string and replaces it with another stri