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

select v.main_dep,s.name,p.age_y,k.department,sum(r.sum_price)as sum_price,sum(r.cost)as cost,o.*
from opdscreen o
inner join ovst v on v.hn=o.hn and v.vstdate=o.vstdate
inner join person p on p.patient_hn=v.hn
inner join spclty s on s.spclty=v.spclty
inner join kskdepartment k on k.depcode=v.main_dep
left join opitemrece r on r.hn=o.hn and r.vstdate=o.vstdate
where (o.vstdate between ‘2014-03-01’ and ‘2014-03-01’ )and (p.age_y >”15″) and v.main_dep in (‘005′,’999’) and
(o.pulse is null or o.bpd is null or o.bps is null or o.bw is null )
group by r.hn,o.vstdate
order by k.department,cost