| Subject | Firebird: the ambiguity database | 
|---|---|
| Author | saharacamel01 | 
| Post date | 2002-11-18T08:47:21Z | 
Doing a test to replace Interbase with Firebird 1.0 lots of my 
queries cause ambiguity errors. (SQL error -204). Most of them I
could solve myself but with this one I need help.
select pa.paneelnr, pa.beslagnr, pa.positie, pa.getoond, a.artikelnr,
a.omschrijving1, a.omschrijving2, a.specificatie, a.prijs
from paneelart pa left outer join artikel a on pa.beslagnr =
a.beslagnr
where pa.paneelnr = :Paneelnr
order by pa.positie
The ambiguity is on beslagnr. Both tables have a field 'beslagnr'.
Thanks in advance.
            queries cause ambiguity errors. (SQL error -204). Most of them I
could solve myself but with this one I need help.
select pa.paneelnr, pa.beslagnr, pa.positie, pa.getoond, a.artikelnr,
a.omschrijving1, a.omschrijving2, a.specificatie, a.prijs
from paneelart pa left outer join artikel a on pa.beslagnr =
a.beslagnr
where pa.paneelnr = :Paneelnr
order by pa.positie
The ambiguity is on beslagnr. Both tables have a field 'beslagnr'.
Thanks in advance.