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

select concat(p.pname,p.fname,’ ‘,p.lname)as name,o.hn,o.vstdate,o.vsttime,concat(p.age_y,’ »Õ ‘ ,p.age_m,’ à´×͹’)as age,if(p.sex=’1′,’ªÒÂ’,’Ë­Ô§’)as sex,d.icd10,i.name as Fullname,i.tname
from ovst o
left join person p on p.patient_hn=o.hn
left join ovstdiag d on d.hn=o.hn and d.vstdate=o.vstdate and d.diagtype=’1′
left join icd101 i on i.code=d.icd10

where o.vstdate in(‘2014-04-24′,’2014-05-26′) and o.spclty in (’13’)
order by o.vstdate,o.vsttime

select vn.hn,vn.vn,vn.cid,concat(p.pname,p.fname,’ ‘,p.lname) as ptname,vn.vstdate,vn.pdx,vn.dx0,vn.dx1,vn.dx2,vn.dx3,vn.dx4,op.icode,d.name as drug,op.qty,(d.unitprice*op.qty) as income,d.antibiotic
from opitemrece op
join vn_stat vn on vn.vn = op.vn
join patient p on p.hn=vn.hn
join drugitems d on d.icode=op.icode
where op.vstdate between ‘2012-11-01’ AND ‘2013-09-30’
group by vn.vn