UPDATE Client SET NoProvince= (SELECT COALESCE((SELECT TOP 1 (CASE WHEN Invoice.AddUser<>1 THEN Invoice.AddUser ELSE 0 END) AS AddUser FROM Invoice WHERE Invoice.NoClient=Client.Numero AND Invoice.NoItem=23 ORDER BY Invoice.AI DESC),0))