Tip แพทย์แผนไทย
ตรวจสอบการมารับบริการ
select p.house_regist_type_id,h2.service_date, h2.hn, h1.health_med_operation_item_id, h1.health_med_provider_id, h1.service_price, h3.icode,
concat(vn.pdx,” “,vn.dx0,” “,vn.dx1,” “,vn.dx2,” “,vn.dx3,” “,vn.dx4,” “,vn.dx5)as diage,pt.pttype,pt.pname,pt.fname,pt.lname,vn.age_y,
h3.health_med_operation_item_name,op.cc,concat(h5.health_med_provider_pname,h5.health_med_provider_fname,” “,h5.health_med_provider_lname) as dname
from health_med_service_operation h1
left outer join health_med_service h2 on h2.health_med_service_id=h1.health_med_service_id
left outer join vn_stat vn on vn.vn=h2.vn
left outer join patient pt on pt.hn=h2.hn
left outer join person p on p.patient_hn=pt.hn
left outer join opdscreen op on op.vn=h2.vn
left outer join health_med_operation_item h3 on h3.health_med_operation_item_id=h1.health_med_operation_item_id
left outer join health_med_service_operation h4 on h4.health_med_service_id=h2.health_med_service_id
left outer join health_med_provider h5 on h5.health_med_provider_id=h4.health_med_provider_id
where h2.service_date between ‘2013-05-01’ and ‘2013-05-31’
and p.house_regist_type_id in (1)
group by h2.vn order by h5.health_med_provider_id
ใส่ความเห็น
คุณต้องเข้าสู่ระบบ เพื่อจะพิมพ์ความเห็น