SELECT
concat('P',c.visit_id) as immunization_plan_schedule_ref_code,
ae.exp_date as schedule_date,
c.dose_time as treatment_number,
c.dose_time as schedule_description,
'Y' as complete,
c.vac_date as visit_date
FROM cid_vaccinate_v2 c
LEFT JOIN vaccinecovid ae on ae.vaccine_id = c.vaccine_id and ae.is_cancel = 0 and c.is_cancel= 0
WHERE c.visit_id = '0002476517'
GROUP BY c.vac_date
ไม่มีความคิดเห็น:
แสดงความคิดเห็น