34,575
社区成员
发帖
与我相关
我的任务
分享
update
b
set
classname=a.classname
from
productclass a,user_productclass b
where
a.classid=b.classid
and
b.userid=15
update user_productclass
set classname=(select classname from productclass pr where pr.classid=u.classid)
from user_productclass u where userid=15
update u set classname=(select classname from productclass pr where
pr.classid=u.classid)
from user_productclass u where userid=15