ชุดคำสั่ง
SELECT cf.distcode AS HOSPCODE
,campur.ampurname AS hosname
,sum(IF(fp.fptype = '1',1,0)) AS '1'
,sum(IF(fp.fptype = '2',1,0)) AS '2'
,sum(IF(fp.fptype = '3',1,0)) AS '3'
,sum(IF(fp.fptype = '4',1,0)) AS '4'
,sum(IF(fp.fptype = '5',1,0)) AS '5'
,sum(IF(fp.fptype = '6',1,0)) AS '6'
,sum(IF(fp.fptype = '7',1,0)) AS '7'
FROM fp
INNER JOIN cfptype ON fp.fptype = cfptype.id_fptype
INNER JOIN person ON fp.HOSPCODE = person.HOSPCODE AND fp.PID = person.PID
INNER JOIN chospital cf ON fp.HOSPCODE = cf.hoscode
INNER JOIN campur ON cf.distcode = campur.ampurcode
WHERE person.NATION <> '099' AND date_serv BETWEEN 0 AND 0 AND campur.changwatcode = '77'
GROUP BY cf.distcode