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