ลองดูจาก...วิธีนี้ ได้ไหมครับโค๊ด: Ada
select count(distinct ps.person_id),p.staff,o.name from person_dmht_screen_summary ps left outer join person_dmht_risk_screen_head p on p.person_dmht_screen_summary_id=ps.person_dmht_screen_summary_id left outer join opduser o on o.loginname=p.staff group by staff order by staff