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

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

0

0