Hi everyone, I hope someone can help me out!

I have 2 tables with 2 related colums: CHARGE_BREAKDOW N with Approvalcode and td columns while MERCHANT_BANK has Appcode and trandate columns.

The data from charge_breakdow n cames to our POS which was updated daily while Merchant_bank data cames from the bank and it's a text file only. Merchant_bank table insert data by using data transformation.

What I need...