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

IBX metadata queries?



With regards,

Martijn Tonies
InterBase Workbench - the developer tool for InterBase
http://www.upscene.com

Firebird Workbench - the developer tool for Firebird
http://www.upscene.com

Upscene Productions
http://www.upscene.com

"This is an object-oriented system.
If we change anything, the users object."