select
a.depart_name 部门,
count(b.user_id)
from
t_depart a,
t_user b
where
a.depart_id=b.Depart_id
group by
a.depart_name
alter table t_depart add(depart_number number(3));update t_depart a set a.depart_number=(select count(*) from t_user b where b.depart_id=a.depart_id) where a.depart_id=b.depart_id
a.depart_name 部门,
count(b.user_id)
from
t_depart a,
t_user b
where
a.depart_id=b.Depart_id
group by
a.depart_name
alter table t_depart add(depart_number number(3));update t_depart a set a.depart_number=(select count(*) from t_user b where b.depart_id=a.depart_id) where a.depart_id=b.depart_id
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货