UPDATE opd_visits o SET o.is_cancel = 1
WHERE o.VISIT_ID in ('0002400936'
,0002400937,0002400938,
0002400939,
0002400940,
0002400941,
0002400942
)
**************************
หาVisit
SELECT o.REG_DATETIME, o.VISIT_ID ,c.cid, c.hn, o.is_cancel, o.staff_id
FROM opd_visits o
INNER JOIN cid_hn c ON o.hn = c.hn
WHERE o.REG_DATETIME >= CURDATE()
AND o.STAFF_ID = 0341
ไม่มีความคิดเห็น:
แสดงความคิดเห็น