Posted by Mark on 07/02/05 11:55

Hello,

how to do a select ... from select in MSSQL similar to Oracle? eg.

select hour
from (
select substring( daily, 9,2 ) as hour
from daytab
where userid = 12
)

results in "incorrect syntax near ')'"

thank you and regards
Mark

• Next in forum: Re: cascaded select
• Prev in forum: Re: T-SQL create self-reference in depending table
• Thread view: cascaded select

[Reply to this message]