By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE tABLe customers (id int , transaction_id int)
CREATE tABLE transactions (transaction_id int,transaction_type int)
update customers
set transaction_id = (
select transaction_id from transactions
where transaction_type IN (select transaction_type from (SELECT transaction_type FROM customers where id = 10) c )
);
Rows matched: 0 Changed: 0 Warnings: 0