kit update รวม

update visitdentalcheck vd
INNER JOIN visit on vd.pcucode=visit.pcucode
and vd.visitno=visit.visitno
set vd.dateupdate=concat(visitdate,SUBSTR(vd.dateupdate,11,9))
WHERE datedental BETWEEN '2016-10-01' AND '2019-09-30';

UPDATE visitdiag vd
INNER JOIN visit on vd.pcucode = visit.pcucode and vd.visitno = visit.visitno
SET vd.dateupdate = CONCAT(visit.visitdate,SUBSTR(vd.dateupdate,11,9))
WHERE visit.visitdate BETWEEN '2016-10-01' AND '2019-09-30';

UPDATE visitdrug vdg
INNER JOIN visit on vdg.pcucode = visit.pcucode and vdg.visitno = visit.visitno
SET vdg.dateupdate = CONCAT(visit.visitdate,SUBSTR(vdg.dateupdate,11,9))
WHERE visit.visitdate BETWEEN '2016-10-01' AND '2019-09-30';

update visit
set dateupdate=concat(visitdate,SUBSTR(dateupdate,11,9))
WHERE visit.visitdate BETWEEN '2016-10-01' AND '2019-09-30';

UPDATE visitancdeliverchild vc
SET vc.tshresult = '8.88'
WHERE (vc.tshresult is null OR vc.tshresult = '')
AND date(vc.dateupdate) BETWEEN '2016-09-01'AND CURDATE();

UPDATE visitdiagaccidentaddress vc
SET vc.urgency = '5'
WHERE vc.urgency = '6'
AND vc.dateaccident BETWEEN '2016-10-01'AND CURDATE();