AnsweredAssumed Answered

Query to get resources listed in Team -> staff for a project

Question asked by deepud on Sep 27, 2012
Latest reply on Sep 27, 2012 by Ruthann Spencer
Hi Experts,

I am using Clarity 12.1 and looking to get all resources listed under Team -> staff for a project...

But my query returns more number of resources than those listed under staff.
Here is the query..

SELECT

srm_resources.full_name,
inv_investments.name

FROM

inv_investments, prteam, inv_projects,
srm_resources

where

inv_investments.id = inv_projects.prid and
prteam.prprojectid = inv_investments.id and
prteam.prresourceid = srm_resources.id and
inv_investments.code = '178234'

Any ideas?

regards,
Deepu.

Outcomes