select x.xn,x.hn,x.vn,x.report_date,x.request_date,x.confirm ,xh.department,concat(p.pname,p.fname,' ',p.lname) as ptname ,i.xray_items_name ,
d.name as report_doctor_name , k.department as request_department ,d2.name as request_doctor_name,
xp.priority_name
from xray_report x
left outer join patient p on p.hn = x.hn
left outer join xray_items i on i.xray_items_code = x.xray_items_code
left outer join doctor d on d.code = x.report_doctor
left outer join kskdepartment k on k.depcode = x.request_depcode
left outer join doctor d2 on d2.code = x.request_doctor
left outer join xray_head xh on xh.vn = x.vn
left outer join xray_priority xp on xp.xray_priority_id = x.xray_priority_id
where x.confirm = 'Y' and x.confirm_read_film <> 'Y' and (x.request_date between '2014-08-04' and '2014-08-04' )
order by x.xn
By : สุชาติ เกตุทอง
ไม่มีความคิดเห็น:
แสดงความคิดเห็น