ora-00979 error

From: Alberto Zen (alberto.zen_at_e-iter.net)
Date: 05/27/04 

Date: Thu, 27 May 2004 19:50:07 +0200

When i try to execute this query i receive an error message ORA-00979: not a
GROUP BY expression.

select
prestazioni.S_DESCR,
prest_gar.S_IDPRESTAZIONE,
count(*) as Totale
from
SGP.PREST_GAR prest_gar,
SGP.PROD_GAR prod_gar,
SGP.PRESTAZIONI prestazioni
where
prod_gar.ID_GARANZIA = prest_gar.ID_GARANZIA
and
prod_gar.ID_PRODOTTO=:IDPROD
and
prestazioni.S_ID = prest_gar.S_IDPRESTAZIONE
group by
prestazioni.S_DESCR, prest_gar.S_IDPRESTAZIONE

If i remove the parameter the query works fine.

Who can help me?

Thanks.

Alberto Zen

Relevant Pages

  • Re: IIf dilemma
    ... John, Here is the SQL..... ... The error message I received is......"You tried to execute a query that did ...
    (microsoft.public.access.queries)
  • Re: "Select" & "Order By" OK- WHERE Doesnt Work !
    ... The error message was "could not execute query". ... format' 'artist'. ...
    (comp.lang.php)
  • Re: "Select" & "Order By" OK- WHERE Doesnt Work !
    ... >> What error message did you get when you executed the query? ... or die ("could not execute query because ... > checked i got the same error message by typing in a load of random ... Tom Thackrey www.creative-light.com tom creative light com do NOT send email to jamesbutler@willglen.net ...
    (comp.lang.php)
  • rename a table
    ... I am trying to rename a table from a query by this statement ... Execute sp_rename 'SubMenuItem', 'Portal_MenuSubItems' ... but it gives me an error message: ... No item by the name of 'SubMenuItem' could be found in the current database ...
    (microsoft.public.sqlserver.programming)
  • Re: Too many expressions in ORDER BY Clause
    ... >several different macros that I am trying to execute that just open a form ... >specified Query in the Query tab, they work fine, no error message. ... >error message only appears when its in the macro connected with the form. ...
    (microsoft.public.access.forms)