update controller c inner join controller_copy cc on c.cCode = cc.cCode
set c.latitude=cc.latitude, c.longitude=cc.longitude
WHERE c.groupId = 41
update controller c inner join controller_copy cc on c.cCode = cc.cCode
set c.latitude=cc.latitude, c.longitude=cc.longitude
WHERE c.groupId = 41