Results 1 to 3 of 3

Thread: Ora-00979

  1. #1
    Join Date
    Apr 2004
    Posts
    2

    Unanswered: Ora-00979

    hi, I have this Query, and throw me the error ORA-00979. I dont kwow why, because Im new in Oracle Development.
    Please, help me!
    Thanks
    pd: My English isnt good, Im speak Spanish. Sorry!

    SELECT A.ID_DESTINATARIO AS ID,A.DENOMINACION AS DENO,
    ( SELECT COUNT(*)
    FROM ENTIDAD B, ENTIDAD_DESTINATARIO C
    WHERE B.ID_CONFIGURACION = A.ID_CONFIGURACION
    AND C.ID_CONFIGURACION = B.ID_CONFIGURACION
    AND C.ID_DESTINATARIO = A.ID_DESTINATARIO AND C.ID_ENTIDAD = B.ID_ENTIDAD
    ) AS CANTPROY,
    ( SELECT SUM(B.MONTO)
    FROM ENTIDAD B, ENTIDAD_DESTINATARIO C
    WHERE (B.ID_CONFIGURACION = A.ID_CONFIGURACION)
    AND C.ID_CONFIGURACION = B.ID_CONFIGURACION
    AND C.ID_DESTINATARIO = A.ID_DESTINATARIO
    AND C.ID_ENTIDAD = B.ID_ENTIDAD) AS MONTO ,
    cast(SA.MUYINSATISFECHO as decimal(19,2)) AS MUY_INSATISFECHO,
    cast(SA.INSATISFECHO as decimal(19,2)) AS INSATISFECHO,
    cast(SA.INDIFERENTE as decimal(19,2)) AS INDIFERENTE,
    cast(SA.SATISFECHO as decimal(19,2)) AS SATISFECHO,
    cast(SA.MUYSATISFECHO as decimal(19,2)) AS MUY_SATISFECHO
    FROM DESTINATARIO A
    LEFT JOIN SA_ENT_DESTINATARIO SA
    ON (A.ID_CONFIGURACION=SA.ID_CONFIGURACION
    AND A.ID_TIPO_DESTINATARIO=SA.ID_TIPO_DESTINATARIO
    AND A.ID_DESTINATARIO=SA.ID_DESTINATARIO)
    WHERE A.ID_TIPO_DESTINATARIO = 1 AND SA.ID_CONFIGURACION = 1

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    Error: ORA 979 Text: not a GROUP BY expression
    ------------------------------------------------------------------------------- Cause: The GROUP BY clause does not contain all the expressions in the SELECT clause.
    SELECT expressions that are not included in a group function, such as AVG, COUNT, MAX, MIN, SUM, STDDEV, or VARIANCE, must be listed in the GROUP BY clause.
    Action: Include in the GROUP BY clause all SELECT expressions that are not group function arguments.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Apr 2004
    Posts
    2

    Unhappy

    I kwow what the error is, but I dont kwow what happends with this query.... in SQL Server and Microsoft Access works fine.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •