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

>--- In ib-support@y..., Helen Borrie <helebor@t...> wrote:
> > It may be that you will need to use fully-qualified column names with IBX
> > for this query in order to persuade it to behave properly...
>
>What do you mean with 'fully-qualified column names'?

select
paneelart.paneelnr,
paneelart.beslagnr,
paneelart.positie,
paneelart.getoond,
artikel.artikelnr,
artikel.omschrijving1,
artikel.omschrijving2,
artikel.specificatie,
artikel.prijs
from paneelart
left join artikel
on paneelart.beslagnr = artikel.beslagnr
where paneelart.paneelnr = :Paneelnr
order by paneelart.positie

But try to examine that parsed SQL!

heLen