On 3/22/2015 6:52 PM, Scott Robison wrote: > Thinking back to when I was first learning SQL, I remember being surprised > in a similar way. To my procedural / object oriented / imperative way of > thinking, the subselect was like a function
Even with this way of looking it at it - wouldn't it be strange to have functions but no mechanism for them to take parameters? A field from an outer query is to a correlated subquery what a parameter is to a function in a traditional imperative language. -- Igor Tandetnik