At 08:47 AM 18-11-02 +0000, you wrote:

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

Seems OK.

Are there any nulls in pa.beslagnr or a.beslagnr?

heLen