Skip to content

Raizcorp Technical Documentation

Query: Qry Count Entrepreneurs Pipeline Phase 3 by Delivery Location

Query: Qry Count Entrepreneurs Pipeline Phase 3 by Delivery Location

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

Tables Referenced

ProcessStep
ProcessStatus
Entrepreneurs

Columns Selected

Entrepreneurs.[Delivery Location ID]
Phase
Count(Entrepreneurs.[Entrepreneur ID])

SQL

SELECT Entrepreneurs.[Delivery Location ID], ProcessStep.Phase, Count(Entrepreneurs.[Entrepreneur ID]) FROM [Entrepreneurs], [ProcessStatus], [ProcessStep]