Select in a From Clause

[kmericle]

Hello all...

In MSSQL I can run the follwoing query, however I cannot in Sybase SQL. Is this prohibited in Sybase? Is there an equivilant anyone can think of?

select column1 from (select column1 from table) t1

Thank you...

 

[VDavid]

Give us more info on what do you want to do?
Lets try to find an equivalent.

David.

 

[LucieLastic]

hi

Is this what you want?

select column1 from t1
where column1 in (select column1 from table)

lou

 

[nickpark]

This is a simple example of an inline view.

It is part of the ANSI standard but is not yet supported by Sybase ASE. Oracle supports it.

e.g.

select count(*)
from (select product,sum(profit) as total_profit
      from sales
      group by product )