โรงพยาบาลจอมพระ

select a.an,dt.vn,dt.* from dtmain dt
left join an_stat a on a.vn=dt.vn

where a.vn is not null and (dt.vstdate between ‘2012-10-01’ and ‘2013-09-30’)

select dtg.dttm_group_id,dtg.name,dtm.name,count(dtm.name)as Total,dtm.code
from dtmain dt
left join dttm dtm on dtm.code=dt.tmcode
left join dttm_group dtg on dtg.dttm_group_id=dtm.dttm_group_id
where (vstdate between ‘2013-10-01’ and ‘2016-10-01’)
group by dtm.name