UPDATE shop_order.PurchaseOrderLine SET LineStatus = 90 FROM shop_order.PurchaseOrderLine b
INNER JOIN shop_order.PurchaseOrder a ON a.PurchaseOrderId = b.PurchaseOrderId
WHERE a.OrderStatus = 90 AND b.LineStatus <> 100