sql 多表更新

update Prob set
KnowId =(
select id from ccss b where b.Content = StandardCalc and b.Content!='' and vid='t'
)
where vid='t'

原文地址:https://www.cnblogs.com/ankeyliu/p/5606560.html