> -----Original Message-----
> Here's another suggestion that doesn't explain your problem, but that
> probably helps you solve it by doing things slightly differently:

[...]

> i.e. no DISTINCT, but move the part that I presume made DISTINCT
> necessary - even though it isn't in any output column - into a simple
> EXISTS part.

Thanks for that, it does work, as you expected. :-)

>
> Though this only helps if my assumptions that the selected column with
> this statement is DISTINCT by nature. And, I guess I'm not the only
> person still curious why your initial statement failed.

TBH, I am still very curious whilst the original DISTINCT didn't work.

Thanks for your help with this, and you'll be please to know that ive
re-factored all joins in the db ;-)

Rgds

Si Carter
http://www.fbtalk.net/ - Web Based Firebird Forum
http://sourceforge.net/projects/fbutils - FBUtils
http://sourceforge.net/projects/dnfbb - Web based, Firebird Powered Forum