1 update tabA 2 set PrintTag=c.dp_state 3 from tabA a 4 inner join tabB b on a.Code=b.design 5 inner join tabC c on b.spdm=c.sp 6 where a.PrintTag is null and c.state='已打印'
Better not to ignore the past but learn from it instead. Otherwise, history has a way of repeating itself.