As Arno said, there is nothing wrong with this query, so the error must be
somewhere else. E.g. if you are using IBO, start by checking KeyLinks.
Somewhere there is an ambiguity, and it is not in your SQL. Most likely it
will be a property you've set, but it could also be in the components you
are using (with IBO a change in Firebird revealed a problem, but this was
quickly resolved months ago - I have no knowledge of other components).

HTH,
Set

At 08:47 18.11.2002 +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'.
>
>Thanks in advance.
>
>
>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/