sql update多表联合更新

 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='已打印'