The and condition and where condition differences after MySQL left join on

Such as:

SELECT * from Table_1 left joins table_2 on table_1.id = table_2.t1_id and table_2.status > 0

SELECT * from table_1 LEFT join table_2 on table_1.id = table_2.t1_id where table_2.status > 0

Two queries were found to be different.

Why there is a difference, which is related to the where query order.

(1): On the following filter conditions are mainly related to the table "and for the primary table filter conditions do not apply."

(2): The filter criteria for the primary table should be placed behind the where, should not be placed behind

(3): We have to differentiate between related tables. If you want to condition query after the connection should be the query pieces

Placed after on.

If you want to filter after the connection is complete, you should put the condition behind the where

(4): For the association table we can actually do the subquery first and then join.

The and condition and where condition differences after MySQL left join on