tab1 JOIN_TYPE tab2

ON cond | USING(col1, …)

JOIN_TYPE:

[INNER ] JOIN

LEFT|RIGHT [OUTER] JOIN

inner/outer refer to the result range:

inner means intersection only

outer means plus left/right part of union

LEFT JOIN 保留左边的所有列，连接后无匹配的用NULL填充