Hi,

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

Sorry - I don't get it ... Does it show an error or not?

You said: "why this query want generate ambiguous message?"


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."

>
> --- 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."
>
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>