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" );
>>