题解 | #找到每个人的任务#
找到每个人的任务
http://www.nowcoder.com/practice/9dd9182d029a4f1d8c1324b63fc719c9
SELECT a.id,a.name,b.content
FROM person as a LEFT JOIN task AS b
ON a.id=b.person_id
ORDER BY a.id
找到每个人的任务
http://www.nowcoder.com/practice/9dd9182d029a4f1d8c1324b63fc719c9
SELECT a.id,a.name,b.content
FROM person as a LEFT JOIN task AS b
ON a.id=b.person_id
ORDER BY a.id
相关推荐