Skip to content

Query: Qry Report Partner Elite Pipeline Step 2-7

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

Tables Referenced

  • ProcessStep
  • Lead Types
  • ProcessStatus
  • Entrepreneurs

Columns Selected

  • Entrepreneurs.[Lead Type ID]
  • [Lead Types].[Lead Type]
  • ProcessStatus.[Step Number]
  • ProcessStep.[Process Step]
  • Count(Entrepreneurs.[Entrepreneur ID])

Where Clause

(((Entrepreneurs.[Division ID])=3))

Order By

[Lead Types].[Lead Type]

SQL

SELECT Entrepreneurs.[Lead Type ID], [Lead Types].[Lead Type], ProcessStatus.[Step Number], ProcessStep.[Process Step], Count(Entrepreneurs.[Entrepreneur ID]) FROM [Entrepreneurs], [ProcessStatus], [Lead Types], [ProcessStep] WHERE (((Entrepreneurs.[Division ID])=3))