update base_school s
set s.sk_teacher_cnt =
(select count(*)
from base_user u
where u.school_id = s.school_id
and u.delete_flag = 0
and u.is_ini = 1
and u.SCHOOL_CHECK_STATUS = 2),
s.report_cnt =
(select count(*)
from base_user u
where u.school_id = s.school_id
and u.delete_flag = 0
and u.is_ini = 1)
本站仅提供存储服务,所有内容均由用户发布,如发现有害或侵权内容,请
点击举报。