I have done something like below but the problem with following statement is it updates every records from MANUAL_TRANSACTIONS table.
stackoverflow.com