It makes difference for OUTER JOINs. The JOIN filter conditions are applied before JOIN. The WHERE conditios are applied after.
>I didn't know you could do that. It works great.
>Thanks to all of you who "joined" in on this. :)
>
>
>>Move filter condition to the JOIN
>>
>> ON Sites_1.permid = History_1.permid;
>> AND History_1._year = ( 2005.0000 );
>> WHERE Sites_1.status = ( "TRP" );
>>
--sb--