select h.*,d.name as doctor_name, concat(pt.pname,pt.fname,' ',pt.lname) as ptname ,
h.form_name ,v.rcpt_money as opaid,a.rcpt_money as ipaid , v.age_y as vage_y,a.age_y as aage_y ,
h.department, lo.lab_items_name_ref
from lab_head h
left outer join patient pt on pt.hn=h.hn
left outer join doctor d on d.code=h.doctor_code
left outer join vn_stat v on v.vn=h.vn
left outer join an_stat a on a.an=h.vn
left outer join lab_order lo on lo.lab_order_number =h.lab_order_number
where h.lab_order_number = 1550
and h.confirm_report='N'
order by h.order_date,h.order_time
หัวข้อ: ขอร้องแหละครับพี่ ๆ ครับช่วยแก้รายงานตัวนี้ให้หน่อยครับ (อ่าน 2627 ครั้ง)