update tabA
set PrintTag=c.dp_state
from tabA a
inner join tabB b on a.Code=b.design
inner join tabC c on b.spdm=c.sp
where a.PrintTag is null and c.state='已打印'
update tabA
set PrintTag=c.dp_state
from tabA a
inner join tabB b on a.Code=b.design
inner join tabC c on b.spdm=c.sp
where a.PrintTag is null and c.state='已打印'
该资源仅限VIP专享下载