0 สมาชิก และ 1 บุคคลทั่วไป กำลังดูหัวข้อนี้
SELECT p.hn,concat(p.pname,p.fname," ",p.lname) as ptname,l.form_name,l.department,l.order_time,l.report_time, sec_to_time(time_to_sec(l.report_time)-time_to_sec(l.order_time)) as watingtimeFROM lab_head lleft outer join patient p on p.hn=l.hnwhere l.order_date between "2013-01-01" and "2013-01-31" order by l.department,l.form_name;