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

select /* p.cid,o.pt_subtype,v.pdx,o.vn,o.hn,concat(p.pname,p.fname,’ ‘,p.lname)as Uname,
o.an,o.vstdate,o.doctor,d.name as dr,
r.send_from_depcode,
r.send_to_depcode,k1.department,
r.send_to_spclty,
o.spclty,s.name,o.last_dep,k.department,os.hpi,os.symptom,os.cc,o.rcpt_disease
*/ count(*),k1.department,s.name
from ovst o
left join spclty s on s.spclty=o.spclty
left join vn_stat v on v.vn=o.vn
left join opdscreen os on os.vn=o.vn
left join kskdepartment k on k.depcode=o.last_dep
left join patient p on p.hn=o.hn
left join doctor d on d.code=o.doctor
left join opd_regist_sendlist r on r.vn=o.vn
left join kskdepartment k1 on k1.depcode=r.send_to_depcode
where (o.vstdate between ‘2016-01-01’ and ‘2016-01-16′) and (o.spclty not in (’03’))
and (v.pdx is null or v.pdx=”)
group by s.name,k1.department
order by r.send_to_depcode

—————————————————————-
select k1.department,s.name,group_concat(distinct o.hn),o.vstdate,count(distinct o.hn)as ‘ÃÒÂ’,os.cc,group_concat(k2.department)as a
from ovst o
left join spclty s on s.spclty=o.spclty
left join vn_stat v on v.vn=o.vn
left join opdscreen os on os.vn=o.vn
left join kskdepartment k on k.depcode=o.last_dep
left join patient p on p.hn=o.hn
left join doctor d on d.code=o.doctor
left join opd_regist_sendlist r on r.vn=o.vn
left join kskdepartment k1 on k1.depcode=r.send_to_depcode
left join ptdepart de on de.vn=o.vn
left join kskdepartment k2 on k2.depcode=de.depcode
where (o.vstdate between ‘2016-02-01’ and ‘2016-02-29′) and (o.spclty not in (’03’))
and (v.pdx is null or v.pdx=”)
group by o.vn,s.name,k.department
order by r.send_to_depcode

select * from opitemrece
where hn=000101213
and vstdate=’2016-01-10′

ปรับ  paidst =02