AFAIK additional conditions for inner join can be placed at the end, eg the
following 2 queries should produce the same result

select ... from t1 inner join t2 on t1.a=t2.a where t1.b>0

select ... from t1 inner join t2 on t1.a=t2.a and t1.b>0

Under what circumstance that one form will be better than the other?

TIA

--
regards,
bill