有一张person表,主键是id,数据如下:
同时还有一张任务表task,主键也是id:
请找出每个人的任务情况(注意:没有任务也要输出),结果按id降序排列,输出如下:
下面正确的SQL查询语句是:
同时还有一张任务表task,主键也是id:
请找出每个人的任务情况(注意:没有任务也要输出),结果按id降序排列,输出如下:
下面正确的SQL查询语句是:
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 DESC;
SELECT p.id, p.name, t.content FROM person AS p JOIN task AS t ON p.id = t.person_id ORDER BY p.id DESC;
SELECT p.id, p.name, t.content FROM person AS p RIGHT JOIN task AS t ON p.id = t.person_id ORDER BY p.id DESC;
SELECT p.id, p.name, t.content FROM person AS p INNER JOIN task AS t ON p.id = t.person_id ORDER BY p.id DESC;