>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?
>
Sure sounds like it.
What is the maximum number of these that can go into one select statement?
Insanity: Doing the same thing over and over and expecting different results.