Skip to content

Query: Qry Report Partner Elite Pipeline Step 1

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

Tables Referenced

  • Lead Types
  • ProcessStatus
  • Entrepreneurs

Columns Selected

  • Entrepreneurs.[Lead Type ID]
  • [Lead Types].[Lead Type]
  • Status
  • ProcessStatus.[Sort Order]
  • Count(Entrepreneurs.[Entrepreneur ID])

Where Clause

(((Entrepreneurs.[Division ID])=3) AND ((ProcessStatus.[Step Number])=1))

Order By

[Lead Types].[Lead Type], ProcessStatus.[Sort Order]

SQL

SELECT Entrepreneurs.[Lead Type ID], [Lead Types].[Lead Type], ProcessStatus.Status, ProcessStatus.[Sort Order], Count(Entrepreneurs.[Entrepreneur ID]) FROM [Entrepreneurs], [ProcessStatus], [Lead Types] WHERE (((Entrepreneurs.[Division ID])=3) AND ((ProcessStatus.[Step Number])=1))