Código SQL [-]UPDATE Movimientos SET TIPO = T.TIPO FROM Movimientos AS M INNER JOIN ( SELECT M.CODIGO ,C.TIPO FROM Movimientos AS M INNER JOIN Clientes AS C ON M.CLIENTE = C.CODIGO GROUP BY M.CODIGO, C.TIPO ) AS T ON T.CODIGO = M.CODIGO WHERE T.TIPO = 1
UPDATE Movimientos SET TIPO = T.TIPO FROM Movimientos AS M INNER JOIN ( SELECT M.CODIGO ,C.TIPO FROM Movimientos AS M INNER JOIN Clientes AS C ON M.CLIENTE = C.CODIGO GROUP BY M.CODIGO, C.TIPO ) AS T ON T.CODIGO = M.CODIGO WHERE T.TIPO = 1