SQL（三）|多表查询之查询3个表

1 连接查询2个表

SQL：

SELECT
pe.id,
pe.`name`,
pe.age,
a.id AS a_id,
a.detail,
a.person_id
FROM
person AS pe
JOIN address AS a ON pe.id = a.person_id

结果如下：

2 连接查询3个表

SQL：

SELECT
pe.id,
pe.`name`,
pe.age,
a.id AS a_id,
a.detail,
a.person_id,
ph.id,
ph.number,
ph.person_id
FROM
person AS pe
# 查几个表就写几个JOIN
JOIN address AS a ON pe.id = a.person_id
JOIN phone AS ph ON pe.id = ph.person_id

结果：