> "LL" == Linh Luong <[EMAIL PROTECTED]> writes:
LL> Hi,
LL> I am trying to do a 2 joins between 3 tables.
LL> ie)
LL> select , 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=SO
Hi,
I am trying to do a 2 joins between 3 tables.
ie)
select , coalesce(TRR.ABC, SOC.ABC) as newABC, ...
from A join (B join C on (..)) on (..)) as TRR
left join
(D join E on (..)) as SOC on (TRR.Field1=SOC.Field2)
When I run this it says that there is an ambiguous field. Yes after
