Sorry but read my post again, it should be
SELECT DBA_INC_LOAN_BANK.LOAN_NUM, Nombre_Sucursal.NUMERO_SUCURSAL, Nombre_Sucursal.SUCURSAL, DBA_INC_LOAN_BANK.BRANCH_NUMBER, Count(DBA_INC_LOAN_BANK.LOAN_NUM) as CountofLoans
FROM (DBA_INC_LOAN_BANK INNER JOIN DBA_INC_MONTHLY_LOAN_MAIN ON DBA_INC_LOAN_BANK.LOAN_NUM=DBA_INC_MONTHLY_LOAN_MA IN.LOAN_NUM) INNER JOIN Nombre_Sucursal ON Right(DBA_INC_LOAN_BANK.BRANCH_NUMBER,3)=Nombre_Su cursal.NUMERO_SUCURSAL
Group By DBA_INC_LOAN_BANK.LOAN_NUM, Nombre_Sucursal.NUMERO_SUCURSAL, Nombre_Sucursal.SUCURSAL, DBA_INC_LOAN_BANK.BRANCH_NUMBER
I notice that Nombre_Sucursal.NUMERO_SUCURSAL is still selected, didn't that give an error as it is not in your table?
Brian