I'm curious: what does the specified syntax do in SQL Server?

I know in Oracle you can do something like

SELECT column1, (SELECT x FROM y WHERE q) AS column2 FROM table1;

This works provided that the inner select ("inline view") returns one row only.

Is this the same thing?

Les


>>Disclaimer: I don't have an Oracle testing environment or I would have tested this myself ;)
>>
>>In SQL Server a subquery such as

Select Column1 = <span style="background:yellow">(Select X From Y Where yadayada)</span>, Column2
>>From Table1

>>
>>is possible. Will it work in Oracle?
>>
>>
>>TIA
>
>No