01.SELECT
02.visit.visitno,
03.ctitle.titlename,
04.person.fname,
05.person.lname,
06.getAgeYearNum(birth,curdate()) AS AGE,
07.person.idcard,
08.person.sex,
09.visit.visitdate,
10.visitdiag.diagcode,
11.cdrug.drugname
12.FROM
13.visit
14.INNER JOIN visitdiag ON visit.visitno = visitdiag.visitno
15.INNER JOIN visitdrug ON visitdiag.visitno = visitdrug.visitno
16.INNER JOIN cdrug ON visitdrug.drugcode = cdrug.drugcode
17.INNER JOIN person ON person.pid = visit.pid
18.INNER JOIN ctitle ON person.prename = ctitle.titlecode
19.WHERE
20.visit.visitdate BETWEEN '2013-01-01' AND '2013-01-31' AND
21.visit.hossub = 11924
22.GROUP BY diagcode
23.ORDER BY visitno
ครับ ถ้าเขียน Query ยากเกินไปก็ทำบน Code ง่ายกกว่าครับ
