Hi,

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

When looking at your query i don't see something wierd that can cause an
ambigous error. Can you post the exact error-message you get ? Which version
of Firebird 1.0 do you use ?

Regards,
Arno Brinkman
ABVisie