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

-----Original Message-----
From: mk_delphi [mailto:mk_delphi@...]
Sent: Monday, September 09, 2002 9:53 AM
To: ib-support@yahoogroups.com
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@egroups.com



Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/