SELECT lhd.lab_order_number,lhd.vn,lhd.hn,vst.vstdate,lhd.order_date,pt.bloodgrp,lor.lab_items_code,lit.lab_items_name,lor.lab_order_result,lit.lab_items_unit,
lit.lab_items_normal_value
FROM lab_head lhd
LEFT OUTER JOIN ovst vst ON vst.vn = lhd.vn
eft OUTER JOIN patient pt ON pt.hn = lhd.hn
LEFT OUTER JOIN lab_order lor ON lor.lab_order_number= lhd.lab_order_number
LEFT OUTER JOIN lab_items lit ON lit.lab_items_code = lor.lab_items_code
WHERE vst.vstdate BETWEEN '2007-02-26' AND '2007-02-26' AND lhd.hn ='0114236'
AND lor.lab_items_code IN (241,1003,1016,1024,1025,94,1028,58,1025,1026,1033,1029,1005)
ORDER BY lor.lab_items_code ASC