-- apps_master.upOverdueTo0 (PROCEDURE)
begin
UPDATE m_outlet1 o1 JOIN bridging_preregis_outlet bpo ON o1.OutletID = bpo.OutletID 
SET o1.Overdue = 0;
end