SELECT o.VISIT_ID as seq,
DATE_FORMAT(date(o.REG_DATETIME),'%Y-%m-%d') as date_serv,
DATE_FORMAT(time(o.REG_DATETIME),'%h:%i:%s') as time_serv,
'' as bloodgrp,
o.WEIGHT as weight,
o.HEIGHT as height,
ROUND((o.WEIGHT / ((o.height / 100) * (o.height / 100))), 2) as BMI,
o.BODY_TEMP as temperature,
o.PULSE_RATE as pr,
o.RESP_RATE as rr,
o.BP_SYST as sbp,
o.BP_DIAS as dbp,
'' as symptom,
s.UNIT_ID as depcode,
s.UNIT_NAME as department
FROM opd_visits o
LEFT JOIN service_units s ON o.unit_reg = s.unit_id
WHERE o.VISIT_ID in ('0002265136' )
ไม่มีความคิดเห็น:
แสดงความคิดเห็น