SQLSearch will help you find these, but it can't help you fix them.

The issue is that it's not necessarily easy to determine what needs to be moved from the WHERE clause to the ON clause. IF you have multiple fields joining these tables, it could be that you do not want all of these conditions in the ON clause.