Nested SELECT statement - possible?

[fyr]

Hi,
I am trying to do a nested query in Sybase. I have done the following query:

Select * from (Select a,b from table)

in the past in Oracle. When I try this in Sybase, it complains of a syntax error. Is it possible in Sybase? And how can it be done?

Thanks
Fyr

 

[mikewoodhouse]

The syntax you describe can't be executed in Sybase. At least, not up to version 11.9.2, which is all I have available right now.

Is it possible to define your nested query as a view and use that?

 

[Hexonx]

Doesn't work in ASE 12.0.0.3, either.

I'm new to Sybase and am surprised how primitive it is compared to MS SQL Server 7.0, not to mention SQL Server 2000.