平时不怎么写SQL,导致这次的乌龙,被同事笑死!!!!
#原SQL语句
SELECT s.depart_name,r.*
FROM sys_depart s
LEFT JOIN rep_epidemic r
ON s.id=r.depart_id
WHERE r.sta_day='2021-12-21'
ORDER BY s.org_code
原因为WHERE条件过滤了LEFT JOIN查询结果,只剩满足WHERE条件的记录。
#修改后SQL语句
SELECT s.depart_name,r.*
FROM sys_depart s
LEFT JOIN
(SELECT *
FROM rep_epidemic
WHERE sta_day='2021-12-21') r
ON s.id=r.depart_id
ORDER BY s.org_code