ชุดคำสั่ง
SELECT campur.ampurcodefull as HOSPCODE
,campur.ampurname as hosname
,sum(IF(cdisease.code504 = '01',1,0)) AS '01'
,sum(IF(cdisease.code504 = '02',1,0)) AS '02'
,sum(IF(cdisease.code504 = '03',1,0)) AS '03'
,sum(IF(cdisease.code504 = '04',1,0)) AS '04'
,sum(IF(cdisease.code504 = '05',1,0)) AS '05'
,sum(IF(cdisease.code504 = '06',1,0)) AS '06'
,sum(IF(cdisease.code504 = '07',1,0)) AS '07'
,sum(IF(cdisease.code504 = '08',1,0)) AS '08'
,sum(IF(cdisease.code504 = '09',1,0)) AS '09'
,sum(IF(cdisease.code504 = '10',1,0)) AS '10'
,sum(IF(cdisease.code504 = '11',1,0)) AS '11'
,sum(IF(cdisease.code504 = '12',1,0)) AS '12'
,sum(IF(cdisease.code504 = '13',1,0)) AS '13'
,sum(IF(cdisease.code504 = '14',1,0)) AS '14'
,sum(IF(cdisease.code504 = '15',1,0)) AS '15'
,sum(IF(cdisease.code504 = '16',1,0)) AS '16'
,sum(IF(cdisease.code504 = '17',1,0)) AS '17'
,sum(IF(cdisease.code504 = '18',1,0)) AS '18'
,sum(IF(cdisease.code504 = '19',1,0)) AS '19'
,sum(IF(cdisease.code504 = '20',1,0)) AS '20'
,sum(IF(cdisease.code504 = '21',1,0)) AS '21'
FROM cdisease504 c504
INNER JOIN cdisease ON c504.group504code = cdisease.code504
INNER JOIN diagnosis_opd ON cdisease.diagcode = diagnosis_opd.DIAGCODE
INNER JOIN chospital cf ON diagnosis_opd.HOSPCODE = cf.hoscode
INNER JOIN campur ON cf.distcode = campur.ampurcode
WHERE diagnosis_opd.date_serv BETWEEN 0 AND 0 AND campur.changwatcode = '77'
GROUP BY cf.distcode