UPDATE query SET query.field1 = tabla.field1, query.field2 = tabla.field2 FROM OPENQUERY(SAP,'SELECT * FROM oracle.Tabla') AS query INNER JOIN tabla ON query.id = tabla.id