Subject Firebird: the ambiguity database
Author saharacamel01
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.