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
ความเห็นล่าสุด