SELECT du_group_id,SUM(count) as count from ((SELECT du_group_id,COUNT(du_group_id) as count from doctor_user where doctor_id=10937 GROUP BY du_group_id ) UNION (SELECT du_group_id,0 as count FROM doctor_user_group dug ))
as duu GROUP BY duu.du_group_id
查询分组 对应记录值
最新推荐文章于 2022-10-20 09:22:55 发布