20180926-MySQL-JOINS

• INNER JOIN

SELECT column_list
FROM t1
INNER JOIN t2 ON join_condition1
INNER JOIN t3 ON join_condition2
...
WHERE where_conditions;

如果列名相同的话，就需要使用区分符号。
where t1.c = t2.c