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

select o.icode,d.did,d.name,o.qty,o.unitprice,o.hn,o.an,d.unitcost,d.ipd_price,o.vstdate
from opitemrece o
left join drugitems d on d.icode =o.icode
where o.hn=’000046778′ and o.an =’570001149′ and (vstdate between ‘2014-05-11’ and ‘2014-05-14’) and (d.unitcost<>”)
order by o.vstdate

select concat(p.pname,p.fname,’ ‘,p.lname)as name,p2.age_y,s.bps,s.bpd,o.icd10,c.*
from clinicmember c
left join ovstdiag o on o.hn=c.hn
left join opdscreen s on s.hn=c.hn
left join patient p on p.hn=c.hn
left join person p2 on p2.patient_hn=c.hn
where c.clinic =’001’ and (o.icd10 between ‘e10’ and ‘e149’) and (s.bps<=130 and s.bpd<=80)
group by c.hn,o.icd10

select concat(p.pname,p.fname,’ ‘,p.lname)as name,p2.age_y,s.bps,s.bpd,o.icd10,c.*
from clinicmember c
left join ovstdiag o on o.hn=c.hn
left join opdscreen s on s.hn=c.hn
left join patient p on p.hn=c.hn
left join person p2 on p2.patient_hn=c.hn
where c.clinic =’002’ and (o.icd10 between ‘i10’ and ‘i159’) and (s.bps<=140 and s.bpd<=90)
group by c.hn,o.icd10

select concat(p.pname,p.fname,’ ‘,p.lname)as name,p.cid,a.age_y,a.hn,a.an,a.regdate,a.dchdate,a.pdx
from an_stat a
left join person p on p.patient_hn=a.hn
where (a.dchdate between ‘2013-10-01’and ‘2014-06-31’)and ((a.pdx between ‘j44’ and ‘j449′) or a.pdx=’j46’)
order by p.cid,a.dchdate