Hi Martijn...
I know, but normally Firebird will show an error message
in this situation...why this SQL will not?
Best regards...

--- In ib-support@y..., "Martijn Tonies" <m.tonies@u...> wrote:
> Hi,
>
> > 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...
> >
>
> You've answered your own question...
>
> select DESCRIZIONE <- from what table? Put a table alias in front
of it.
>
>
> With regards,
>
> Martijn Tonies
> InterBase Workbench - the developer tool for InterBase
> http://www.upscene.com
>
> Firebird Workbench - the developer tool for Firebird
> http://www.upscene.com
>
> Upscene Productions
> http://www.upscene.com
>
> "This is an object-oriented system.
> If we change anything, the users object."