找到每个人的任务

简介

left join

select a.id, a.name, b.content from
person as a
left join task as b
on b.person_id = a.id
order by a.id;