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

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