UPDATE SZ4020 SET Z4_VEND1 = '999999' FROM SZ4020 INNER JOIN SZ5020 ON SZ4020.Z4_NUMCTR = SZ5020.Z5_NUMCTR WHERE Z4_CLIENTE BETWEEN '001385' AND '002621' UPDATE SZ5020 SET Z5_GERCOM = '2' FROM SZ5020 INNER JOIN SZ4020 ON SZ5020.Z5_NUMCTR = SZ4020.Z4_NUMCTR WHERE Z4_CLIENTE BETWEEN '001385' AND '002621' **********************Verificações ******************* Select * from SZ4020 WHERE Z4_VEND1 = '' SELECT * FROM SZ4020 INNER JOIN SZ5020 ON SZ4020.Z4_NUMCTR = SZ5020.Z5_NUMCTR WHERE Z4_CLIENTE BETWEEN '001385' AND '002621' SELECT * FROM SZ5020