Yes that is what i want to count sorry for not saying it i forgot
so it would lokk like this
SELECT DBA_INC_LOAN_BANK.LOAN_NUM, Nombre_Sucursal.NUMERO_SUCURSAL, Nombre_Sucursal.SUCURSAL, DBA_INC_LOAN_BANK.BRANCH_NUMBER
FROM (DBA_INC_LOAN_BANK INNER JOIN DBA_INC_MONTHLY_LOAN_MAIN ON...