make a quey of a query 1

[russland]

hi,

how could i do a query of a query. respektively a select from a select statement?

 

[PHV]

Something like this ?
SELECT * FROM (
SELECT ... FROM ... WHERE ...
) A INNER JOIN (
SELECT ... FROM ... WHERE ...
) B ON A.SomeCol = B.AnotherCol

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[russland]

hm.... i didn't know something like that is possible?! i check and give you the desevered star if fine. however, thanks for your reply.

cheers for now.

 

[russland]

this s*** is just funtastic! workes great. I didn't know you could even encapsulate within the joins. great. thanks a lot.