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 !