I would think it does the same thing as your example below. Learn something new every day. You are in effect selecting a constant value for that particular column. Thanks.
>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
Mark McCasland
Midlothian, TX USA