>>>>> "LL" == Linh Luong <linh(dot)luong(at)computalog(dot)com> writes:
LL> I am trying to do a 2 joins between 3 tables.
LL> select <some field>, coalesce(TRR.ABC, SOC.ABC) as newABC, ...
LL> from A join (B join C on (..)) on (..)) as TRR
LL> left join
LL> (D join E on (..)) as SOC on (TRR.Field1=SOC.Field2)
LL> When I run this it says that there is an ambiguous field. Yes after the
LL> join for TRR and SOC they both contain a fields name ABC. How can I
LL> rename this field in the sql statement or how can I make it so the sql
LL> statement know that they are different.
LL> Please help.. .thanks
You have to use full-qualifyed field names, like this:
select trr.abc, soc.abc,....
In addition you can use aliases for field names:
select trr.abc as abc1, soc.abc as abc2, ....
Anatoly K. Lasareff Email: tolik(at)aaanet(dot)ru
In response to
pgsql-sql by date
|Next:||From: Tom Lane||Date: 2001-05-29 13:46:03|
|Subject: Re: Re: [SQL] Difficult SQL Statement |
|Previous:||From: Tim Barnard||Date: 2001-05-28 22:36:22|
|Subject: Re: [SQL] Difficult SQL Statement|