Re: mistake, error, or something else ?

From: Mike <mbrugo_at_despammed.com>
Date: Mon, 27 Oct 2003 14:33:48 GMT
Message-ID: <3taqpvc6mqnpnueb4ruh0j872cqmcp7vh8@4ax.com>

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

>But it is 'sucessful'. Well it won't retrieve anything, but it's valid
>syntax.
>
>(select distinct c from t2)
>
>in this sub query is the same as
>
>(select distinct t1.c from t2)
>
>and that's legal, but fairly useless code.

i've understand, but it's not much logical

can you explain me why parser consider the column named in subquery like a column owned by t1 and not by t2 ?

Tia

Mike Received on Mon Oct 27 2003 - 08:33:48 CST