Recent content by icedearth

  1. I

    How to create a teble from a query

    Hi! I have a result of a query and i want to make a table from that result.
  2. I

    How To New

    Hi! I got this two pictures one is the query and the other is the result of the query now i just want to group by sucursal and how many are them.
  3. I

    How To

    Hi! In here you see the query and the result. In the result i need to group by sucursal and count by numero_sucursal. to see how many loan_num are by sucursal. and the rest i want it to stay as it is.
  4. I

    How do I?

    who can help me in this matter
  5. I

    How do I?

    i think i put it the wrong way and gave me various errors. and i want to export this to excel if this is possibble.
  6. I

    How do I?

    Hi! I want to count loan_num nad how many accounts by branch something like the picture of excel. if i need something else tell me. thanks appreciated
  7. I

    Now it gave me this

    thanks again but i made a mistake on counting is doing something that could gave the total of how many loan number of every sucursal and region the last field i forgot to tell you about it. how i can insert a picture of this that you could understand
  8. I

    Now it gave me this

    Yes that is the name of the table and it gave me this error in operator without () in query expression 'dba_inc_loan_bank.loan_num=dba_inc_monthly_loan_main.loan_num'
  9. I

    Now it gave me this

    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...
  10. I

    Now it gave me this

    sorry it won't happened again. so how i can count them
  11. I

    Now it gave me this

    and i want to count how many are they
  12. I

    If this is the correct join

    thanks brianwarnock
  13. I

    Now it gave me this

    Thanks Brianwarnock Now it ask me this
  14. I

    If this is the correct join

    so it could lokk like this SELECT DBA_INC_LOAN_BANK.LOAN_NUM, Nombre_Sucursales.NUMERO_SUCURSAL, Nombre_Sucursales.SUCURSAL, DBA_INC_LOAN_BANK.BRANCH_NUMBER FROM (DBA_INC_LOAN_BANK INNER JOIN DBA_INC_MONTHLY_LOAN_MAIN ON DBA_INC_LOAN_BANK.LOAN_NUM = DBA_INC_MONTHLY_LOAN_MAIN.LOAN_NUM); INNER...
  15. I

    If this is the correct join

    SELECT DBA_INC_LOAN_BANK.LOAN_NUM, Nombre_Sucursales.NUMERO_SUCURSAL, Nombre_Sucursales.SUCURSAL, DBA_INC_LOAN_BANK.BRANCH_NUMBER FROM (DBA_INC_LOAN_BANK INNER JOIN DBA_INC_MONTHLY_LOAN_MAIN ON DBA_INC_LOAN_BANK.LOAN_NUM = DBA_INC_MONTHLY_LOAN_MAIN.LOAN_NUM) RIGHT JOIN Nombre_Sucursales ON...
See more
Top Bottom