Query ช่วยกรองโรคตามเกณฑ์การตรวจสอบ OPD 



SELECT
p.hn,
p.cid,
p.fname,
p.lname,
v.sex,
v.age_y,
v.vstdate,
v.pdx
FROM
vn_stat AS v
INNER JOIN patient p ON v.hn = p.hn
WHERE
v.vstdate BETWEEN '20161001' AND '20161231'
AND
((SUBSTR(v.pdx,1,1) in('A','B','E','I','J','K','M','O','R','S','Z')
OR
SUBSTR(v.pdx,1,3) BETWEEN 'D50' AND 'D89'))