Member Avatar for omaramo

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 because: reapplied code tags
  • 2 Contributors
  • 1 Reply
  • 121 Views
  • 20 Hours Discussion Span
  • Latest Post Latest Post by Philippe.Lahaie
Member Avatar for Philippe.Lahaie

does the rest of your query function well if you take the group by out ?

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.