Re: ORA-00918 expected but ...

From: Torsten Edler <Torsten.Edler_at_googlemail.com>
Date: 13 Apr 2007 04:39:45 -0700
Message-ID: <1176464385.839996.49160@y80g2000hsf.googlegroups.com>

On 11 Apr., 17:18, DA Morgan <damor..._at_psoug.org> wrote:
> There is no ambiguity. You aliased t3 to be "a" and you joined
> t1.x to a.x (which is t3.x).

I think you got me wrong? I meant x "plain x", third selected column from

> select distinct t1.x, y1, x, t2.x, a.x
> from t1
> left outer join t2 on t1.x=t2.x
> left outer join t3 a on t1.x=a.x
> ;

is ambiguous, as it could come from t1,t2 or a. Received on Fri Apr 13 2007 - 06:39:45 CDT