mysql数据库三表查询,sqlite3多表查询

1 连接查询2个表

SQL：

SELECTpe.id,pe.`name`,pe.age,a.id AS a_id,a.detail,a.person_idFROMperson AS peJOIN address AS a ON pe.id = a.person_id

结果如下：

2 连接查询3个表

SQL：

SELECTpe.id,pe.`name`,pe.age,a.id AS a_id,a.detail,a.person_id,ph.id,ph.number,ph.person_idFROMperson AS pe# 查几个表就写几个JOINJOIN address AS a ON pe.id = a.person_idJOIN phone AS ph ON pe.id = ph.person_id

结果：