AnsweredAssumed Answered

Query to list all projects that do not belong to a progra,

Question asked by matpj on Jun 15, 2010
Latest reply on Jun 15, 2010 by Dave
Hi guys,

I may be going about this the wrong way, but I need to run some SQL that will return a list of all projects that do NOT belong to a program.

I thought this might do it:
select * from niku.srm_projects p where p.is_active = 1 and p.is_program = 0 

and p.unique_name NOT  (select prexternalid from niku.prtask t, niku.srm_projects p where t.prprojectid = p.id and p.is_program = 1)
I am using clarity 7.5.3
but this query seems to take forever to run with nothing coming back.
Is there a simpler method that anyone can suggest?


Regards,
Matt

Outcomes