Update in linked server table between MSSQL and POSTGRESS?

Question

SQL Server

Good time everyone, please tell me in this survey:
There is a table in the database on the MSSQL 2008 server, the POSTGRESS database is connected to it through a linked server, I'm trying to update the data in the table like this:

UPDATE openquery(MOB, 'select amount from account_balance')
SET amount=bal
FROM openquery  (MOB, 'select amount, account_barcode from account_balance') rem_k 
JOIN (SELECT [general].[dbo].[account].bal, [general].[dbo].[account].barcode FROM [general].[dbo].[account])
[account] ON  rem_k.account_barcode=barcode

But this query updates all records with the same number in all values, although if you make a query like this:

SELECT rem_k.amount, rem_k.account_barcode, [general].[dbo].[account].bal
FROM openquery  (MOB, 'select amount, account_barcode from account_balance') rem_k 
LEFT OUTER JOIN
[general].[dbo].[account] ON  rem_k.account_barcode=[general].[dbo].[account].barcode
ORDER BY barcode

Then it displays the data correctly, tell me how to update it correctly?

Answer 1

openquery and update