select from subquery

[MarekD]

Hi.
I'm new in SqlServer programing.
Is it possible to do something like this ( It is common construction in oracle )

Select X from(
select a+1 as X from tab1
)

without creating view containig subquery ?

thx. MD

[Simon Hayes]

"MarekD" <ma*******@poczta.onet.pl> wrote in message
news:54**************************@posting.google.c om...

Hi.
I'm new in SqlServer programing.
Is it possible to do something like this ( It is common construction in
oracle )

Select X from(
select a+1 as X from tab1
)

without creating view containig subquery ?

thx. MD

Yes, but you need to give the derived table an alias:

Select X from(
select a+1 as X from tab1
) dt

Simon

[louis]

Yes. Check out this article:
http://www.microsoft.com/technet/pro.../sqlorcle.mspx.

With MSSQL, you'll need an alias.

Select X from(
select a+1 as X from tab1
) as myAlias