Re: mistake, error, or something else ?

On Mon, 27 Oct 2003 14:36:42 +0000 (UTC), Rob Cowell <rjc4687_at_hotmail.com> wrote:

>Because a sub query can reference columns from tables in the main query.
>The parser would consider the column if it existed in t2. But it knows
>column c doesn't exist in t2, so assumes you mean column c in t1 which
>is also in the scope of the sub query.

Thanks Rob Received on Mon Oct 27 2003 - 08:43:50 CST