โรงพยาบาลจอมพระ

1.ประมวลผลPerson

select * from person

2.ประมวลผลVn_stat Joinกับ patient โดยใช้คำสัง

select pt.*,vs.*
from vn_stat vs
left outer join patient pt on pt.cid=vs.cid
where vs.vstdate between ‘2012-11-01’ and ‘2013-07-14’
group by vs.cid

แล้วนำไปmatกันในAccess

select pt.cid,vn.hn,pt.pname,pt.fname,pt.lname,vn.age_y,vn.age_m,vn.vstdate,vn.pdx,vn.dx0,vn.dx1,vn.dx2,vn.dx3,vn.dx4,vn.dx5
from vn_stat vn
left outer join patient pt on vn.hn=pt.hn
Where vn.pdx like’e66%’ or vn.dx0 like’e66%’ or vn.dx1 like’e66%’ or vn.dx2 like’e66%’ or vn.dx3 like’e66%’ or vn.dx4 like’e66%’ or vn.dx5 like’e66%’
GROUP BY vn.hn

select concat(pt.pname,pt.fname,’ ‘,pt.lname) as name,vs.*
from vn_stat vs
left outer join patient pt on vs.hn=pt.hn
where (pdx=’z716′ or dx0=’z716′ or dx1=’z716′ or dx2=’z716′ or dx3=’z716′ or dx4=’z716′ or dx5=’z716′)
and (pdx=’z720′ or dx0=’z720′ or dx1=’z720′ or dx2=’z720′ or dx3=’z720′ or dx4=’z720′ or dx5=’z720’)