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

>--- In ib-support@y..., Helen Borrie <helebor@t...> wrote:
> > Seems OK.
> >
> > Are there any nulls in pa.beslagnr or a.beslagnr?
> >
>
>No, the outer join came in when trying lots of queries to get the
>ambiguity away. It's not necessary. But how would that cause
>ambiguity between fieldnames?

It probably shouldn't; I was looking hard for something to explain it,
thinking perhaps there could be some problem if null were being compared
with null, with that left join involved.

But since you now say you are using IBX, I think you have found the cause.

heLen