Query: Qry Count Current Exited Entrepreneurs by Principal Project

Type: Select
Has Parameters: Yes
Has Joins: No
Has Subquery: No

Tables Referenced

• Principal Project Pillars
• Entrepreneur Company Principal Projects
• Entrepreneur Company
• Entrepreneur Company Programme Years
• Entrepreneurs

Columns Selected

• [Principal Project Pillars].[Principal Project ID]
• Count(Entrepreneurs.[Entrepreneur ID])

Where Clause

((([Entrepreneur Company].[Company Status ID])=4) AND ((Entrepreneurs.[Process S

SQL

SELECT [Principal Project Pillars].[Principal Project ID], Count(Entrepreneurs.[Entrepreneur ID]) FROM [Entrepreneurs], [Principal Project Pillars], [Entrepreneur Company], [Entrepreneur Company Programme Years], [Entrepreneur Company Principal Projects] WHERE ((([Entrepreneur Company].[Company Status ID])=4) AND ((Entrepreneurs.[Process S