AnsweredAssumed Answered

SQL to show all projects excluding sub-projects

Question asked by JoostBreggeman76041091 on Jun 15, 2016
Latest reply on Jun 16, 2016 by JoostBreggeman76041091

Hi,

 

I am looking for a query that shows me all projects with or without subprojects but EXCLUDING the subprojects.

 

So e.g. I have the following projects

 

x = project without subproject

y = project with subproject

z = subproject

 

then the query should only show x,y

 

any idea which query to use?

 

thanks

Outcomes