The Dialect is 3,
the returned DESCRIZIONE field come from CLASSI_MACCHINE
Best regards,
Marco

--- In ib-support@y..., "Wilson, Fred" <fred.wilson@b...> wrote:
> I'm interested in which DESCRIZIONE (from which table) the query is
> returning ??
> Also, which Dialect is the database ?
>
>
> Best regards,
> Fred Wilson
> SE, Bell & Howell
> fred.wilson@b...
>
> -----Original Message-----
> From: mk_delphi [mailto:mk_delphi@y...]
> Sent: Monday, September 09, 2002 9:53 AM
> To: ib-support@y...
> Subject: [ib-support] Re: Why this query want generate ambiguos
> messages?
>
>
> Sorry Martijn... :(
>
> NO error messages from Firebird....
>
> Ciao
>
>
>
> --- In ib-support@y..., "Martijn Tonies" <m.tonies@u...> wrote:
> > 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@e...
> > >
> > >
> > >
> > > Your use of Yahoo! Groups is subject to
> http://docs.yahoo.com/info/terms/
> > >
> > >
> > >
>
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@e...
>
>
>
> Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/