I just realized that what I say below was wrong in this case (oops...).
That is what you get for not using joins in this way a lot :)

Mark

Mark Rotteveel wrote:

> The position of that condition is more a matter of 'taste' and maybe of
> optimization (I am not sure how the optimizer of Firebird handles this),
> the end result of my query and the version below should be the same
> (although the execution time may differ). However semantically, the ON
> condition should only contain the columns used for the join, not any
> 'other' select-conditions.

--
Mark Rotteveel <Avalanche1979@...>