Subject Re: [firebird-support] Theory about join vs where
Author Dimitry Sibiryakov
> In this case, putting test about year or quantity in join will not
> produce a different result
> But what about efficiency ?

In this case - no differences. Optimizer will gather all conditions
into one pile.

SY, SD.