Re: resolving ambiguous column name in subquery

2005-04-04 Thread Tom Cunningham
I take it all back. I see now why this behaviour is desirable, or at least standard. E.g., see: https://aurora.vcu.edu/db2help/db2s0/c2corr.htm On Apr 4, 2005 2:40 PM, Tom Cunningham <[EMAIL PROTECTED]> wrote: > Hi, the following seems wrong to me. Not sure whether this is a bug. > > In short:

resolving ambiguous column name in subquery

2005-04-04 Thread Tom Cunningham
Hi, the following seems wrong to me. Not sure whether this is a bug. In short: a column-name in a subquery can refer to a table *outside* of the subquery (fair enough), but if the column-name is ambiguous between *inside* and *outside*, the parser assumes that it refers to the *inside* context. I