Query of a query

[jpaulino]

Hi all,

I want to do a query of a query of a query. Any help ?

Tanks

 

[AlexCuse]

something like this?

select a.col1, a.col2, a.col5
from
( 
select z.col1, z.col2, z.col3, z.col4, z.col5
from (
      select * from leTable
      ) z
) a

There are numerous ways to do what you're trying to do, but you need to be a tad more specific. Some things that might be helpful include:

1. Database you're using
2. What your data looks like
3. What desired output would be from the query, the query of a query, and the query of a query of a query.

Good Luck,

Alex

Ignorance of certain subjects is a great part of wisdom

 

[SQLDenis]

OOohh that, no problem ;-)

Here you go

use pubs


select * from 
(select * from 
(select * from orders) z
where orderprice >10) x
where orderprice > 15

Somehow I don't think that this is what you wanted



Denis The SQL Menace
--------------------
SQL Server Code,Tips and Tricks, Performance Tuning
Google Interview Questions

 

[Andrzejek]

You also may want to check .Filter of a recordset.



Have fun.

---- Andy

 

[SBerthold]

Have a look into "CREATE VIEW" (or "CREATE PROCEEDURE", if tables get updated).

Then you can create 2 Views and then, for the recordset, base your Sql LEFT JOIN statment off of the two Views.