UPDATE LOGNFE SET VALORNOTA = (SELECT TOTAL FROM PEDIDOS WHERE NRNOTA=LOGNFE.NRNOTA);
COMMIT;

