อยากให้ขึ้น ชื่อเตียง ในใบรายงานผล LAB ครับ

[Bluebird]

select concat(p.pname,p.fname,"  ",p.lname) as ptname,
d.name as request_doctor_name,
h.*,l.*,i.lab_items_unit,i.lab_items_normal_value ,i.lab_items_name
from lab_head h
left outer join lab_order l on l.lab_order_number=h.lab_order_number and l.lab_order_result IS NOT NULL and l.lab_order_result<>''
left outer join lab_items i on i.lab_items_code=l.lab_items_code
left outer join patient p on p.hn=h.hn
left outer join doctor d on d.code=h.doctor_code
where h.lab_order_number='258'

[por]

ลองดูครับ

h.*,l.*,i.lab_items_unit,i.lab_items_normal_value ,i.lab_items_name,ipa.bedno
from lab_head h
left outer join lab_order l on l.lab_order_number=h.lab_order_number and l.lab_order_result IS NOT NULL and l.lab_order_result<>''
left outer join lab_items i on i.lab_items_code=l.lab_items_code
left outer join patient p on p.hn=h.hn
left outer join doctor d on d.code=h.doctor_code
left outer join ipt ip on ip.hn=p.hn
left outer join iptadm ipa on ipa.an = ip.an
where h.lab_order_number='258'

[Bluebird]

select concat(p.pname,p.fname,"  ",p.lname) as ptname,
d.name as request_doctor_name,
h.*,l.*,i.lab_items_unit,i.lab_items_normal_value ,i.lab_items_name ,ipa.bedno
from lab_head h
left outer join lab_order l on l.lab_order_number=h.lab_order_number and l.lab_order_result IS NOT NULL and l.lab_order_result<>''
left outer join lab_items i on i.lab_items_code=l.lab_items_code
left outer join patient p on p.hn=h.hn
left outer join doctor d on d.code=h.doctor_code
left outer join ipt ip on ip.hn=p.hn
left outer join iptadm ipa on ipa.an = ip.an
where h.lab_order_number='258'

ปรากฏตามรูป

[por]

select concat(p.pname,p.fname,"  ",p.lname) as ptname,
d.name as request_doctor_name,
h.*,l.*,i.lab_items_unit,i.lab_items_normal_value ,i.lab_items_name,ipa.bedno
from lab_head h
left outer join lab_order l on l.lab_order_number=h.lab_order_number and l.lab_order_result IS NOT NULL and l.lab_order_result<>''
left outer join lab_items i on i.lab_items_code=l.lab_items_code
left outer join patient p on p.hn=h.hn
left outer join doctor d on d.code=h.doctor_code
left outer join iptadm ipa on ipa.an = h.vn
where h.lab_order_number='258'

[Bluebird]

ขอบคุณครับ