sql - Updating a column using set criteria -

i want update kyc5.status scanned if same kyc5.wallet_number present in jewel_scan2.customer_wallet.

so far have used following code:

update kyc5  set [status_] = 'scanned' customer_wallet = jewel_scan2.customer_wallet

but error message shows:

the multi-part identifier "jewel_scan2.customer_wallet" not bound.

any solution this? should use update inner join?

any highly appreciated.

try add jewel_scan2 table from section below

update kyc5  set [status_]='scanned' jewel_scan2 j kyc5.customer_wallet= j.customer_wallet

IO