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:
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