sfun28
asked on
select from a select statement
Folks,
lets say I have a select statement that returns a table the way I want it. How can I select from that table?
so Select * from (my table constructed from a select statement) where BlaBlaBla>2
lets say I have a select statement that returns a table the way I want it. How can I select from that table?
so Select * from (my table constructed from a select statement) where BlaBlaBla>2
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Aneesh
did you check my solution ?
ASKER
sorry...i just asked to split the points. I didn't see yours.
ASKER
actually your solution was better
>actually your solution was better
you dont really need to create a temptable here ,
you dont really need to create a temptable here ,
ASKER
agreed. i'm waiting for them to get back to me on my request for attention. at that point I'll split the points since I already accepted the other solution. sorry!