I think you mean "won't", not "want", which has confused everyone a
little.

In my FB 1.0 installation, if I do a query of the type

SELECT FLD FROM TABLE_1 T1
JOIN TABLE_2 T2
ON T1.KEY = T2.KEY

if FLD exists in both tables, I get an ambiguity error.
So you are right. Your query should show an error. It looks like
there is something wrong with your installation or your database.

Roger Vellacott
Passfield Data Systems

--- In ib-support@y..., "mk_delphi" <mk_delphi@y...> wrote:
> Hi all
> I am using FB 1.0
> why this query want generate ambiguous message?
>
> select DESCRIZIONE from MACCHINE m
> left outer join DEPOSITI d on d.oid=m.oid_deposito
> left outer join CLASSI_MACCHINE c on c.oid=m.oid_classe_macchina
> where d.oid=13055
>
> both DEPOSITI and CLASSI_MACCHINE own a DESCRIZIONE field...
>
> Ciao