The centralized type difference of MySQL multi-table query

1, inner connection inner JOIN

An inner connection, also known as an equivalent connection, inner join produces a set of data that conforms to both A and B tables.

INNER JOIN syntax

SELECT * FROM A inner join B on a.name = B.name;

2, natural connection category left join and right join
Left join, (or left outer join: equivalent in MySQL, we recommend using the left join. A left connection from the left table (A) produces a complete set of records, with matching records (right table (B)). If there is no match, the right side will contain null.
Right Join table produces a complete set of records with matching records (left table) if there is no matching left table to null

Left JOIN connection syntax

SELECT * from A LEFT join B on a.name = B.name;

Right JOIN syntax

SELECT * from A LEFT join B on a.name = B.name;

The centralized type difference of MySQL multi-table query