34,587
社区成员
发帖
与我相关
我的任务
分享
update A set A.Nowtype='到期'
from A join (
select STUDENTID
from B
group by STUDENTID
having count(*)=sum(case when Isend='到期' then 1 else 0 end)
) T on A.STUDENTID=T.STUDENTID
update A
set A.nowtype = '到期'
from A
inner join B on A.STUDENTID=B.STUDENTID and B.Isend='到期'