I need sql query for Suppliers bank details, along with my newly created IBY audit table

Team,

I have created audit table on supplier bank accounts table: IBY_EXT_BANK_ACCOUNTS.  New audit table is IBY_EXT_BANK_ACCOUNTS_A.

Now I need a query for these bank details along with Operating Unit, Supplier, Supplier site, bank account name, bank account number,new_bank account name, new_bank account number,..etc.

I have created below query, but getting duplicates for few suppliers. Can some one help to get accurate query (should be like my query result count=new Audit table alone record count).

SELECT IBYA.ext_bank_account_id,

         asp.segment1 vendor_num,

         asp.vendor_name,