2021.01.08 显示不全,例如左表null数据被过滤,右表也不显示
#方法一:显示不全,例如左表null数据被过滤,右表也不显示
SELECT
s.name,
count(*) 'count'
from street_notice r
left join sys_user s on s.id = r.user_id
WHERE
s.id = #{wbUserId}
and r.s_createtime like concat('%',#{wbTime},'%')
group by s.id
#方法二:解决方法一问题,分开查询
SELECT
s.name,
(
select count(*) from
street_notice r
where
s.id = r.user_id and
r.s_createtime like concat('%',#{wbTime},'%')
) 'count'
from sys_user s
WHERE
s.id = #{wbUserId}
group by s.id