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

select r.vn,r.refer_date,r.refer_cause,r.refer_number,r.doctor,d.name,r.refer_point,r.department,r.refer_time,r.hn,r.pdx,r.depcode,r.spclty
from referout r
left join doctor d on d.code=r.doctor
where r.refer_date between ‘2014-10-01’ and ‘2014-10-31’ and ( r.refer_cause is null or r.refer_cause=” )

select s.name,v.vn,v.hn,v.vstdate,v.spclty,k.department,k1.department as fromDepart,o.*
from vn_stat v
left join spclty s on s.spclty=v.spclty
left join opd_regist_sendlist o on o.vn=v.vn
left join kskdepartment k on k.depcode=o.send_to_depcode
left join kskdepartment k1 on k1.depcode=o.send_from_depcode
where v.vstdate between ‘2014-10-01’ and ‘2014-10-31’ and (v.pdx is null or pdx=”)
order by opd_regist_sendlist_id desc