Yes, because filter and join have to be done at the same time
>I do prefer JOIN. But do you think that it is possible that using WHERE produces intermediate results of the size of a Cartesian product, even if the end result is correct?
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer