Sybase - Subquery in FROM clause

Question

I'm using Sybase ASE 12.5.0.3 and I'm unable to do subqueries like:

select * from (select '1' union select '2' ) X

I've been looking around and as far as I know it should be possible after Sybase ASE 12, am I doing something wrong, or is it not possible with this version???

Edit - Even after changing the query to:

select * from (select '1' as col1 union select '2' as col1 ) X

So even giving alias to the columns, it fails anyways...

Answer 1

Without seeing an error message, it appears that you need to give column aliases in your sub-query:

select * 
from 
(
    select '1' as yournewCol 
    union 
    select '2' as yournewCol
) X

Answer 2

You need to give your columns name. Try this: