思路:左连接,再根据id排序
注意:这里person的id对应task中的person_id
完整代码:
SELECT p.id, p.name, t.content
FROM person AS p LEFT JOIN task AS t
ON p.id = t.person_id
ORDER BY p.id
思路:左连接,再根据id排序
注意:这里person的id对应task中的person_id
完整代码:
SELECT p.id, p.name, t.content
FROM person AS p LEFT JOIN task AS t
ON p.id = t.person_id
ORDER BY p.id