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



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?