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
