| nested queries [message #372529] |
Tue, 20 February 2001 06:21  |
sean talbot
Messages: 1
Registered: February 2001
|
Junior Member |
|
|
Hi I want to run a 'nested query' in oracle, but cant get the syntax right can anybody help?
My query looks something like this
select (criteria) from
[[select (criteria) (from (tables) where (conditions)]] where (conditions)
In other word a select query based on the results of another select query
|
|
|
|
| Re: nested queries [message #372547 is a reply to message #372529] |
Wed, 21 February 2001 11:56  |
LB
Messages: 13
Registered: September 2000
|
Junior Member |
|
|
Select col1, col2
from (select col1, col2 from table1 where....)
where conditions;
The above should work.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
