0

Hi,
can you help me please, i have to build a query and i have a problem in the group by expression
==> error message: not a group by expression

my query:

select 

       ress.nom nom_ress,

       task.nom tache,
       max(tr.entrydate),
       ass.prstart,
       ass.prfinish,
       nvl(ass.practsum,0) service_fait,
       nvl(ass.prestsum,0) service_à_faire,
       prj.nom projet,
       tr.resource_class,
       tr.transclass,
       tr.project_department

from prassignment ass,   ppa_wip tr, 
     (select ress.id ress_id,
      ress.full_name nom
      from srm_resources ress) ress,

     (select tsk.prid task_id,
             tsk.prname nom
       from prtask tsk) task, 

      (select inv.id id,
              inv.name nom
       from inv_investments inv) prj 

where tr.task_id=ass.prtaskid
and tr.transtype ='X'
and task.task_id=ass.prtaskid
and ress.ress_id= ass.prresourceid
and tr.investment_id= prj.id
group by  ress.nom

thanks !

Edited by diafol: reapplied code tags

2
Contributors
1
Reply
3
Views
5 Years
Discussion Span
Last Post by Philippe.Lahaie
This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.