Skip to content

Query: JB Entrepreneurs With No Pipeline

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

Tables Referenced

  • ProcessStatus
  • Entrepreneurs

Columns Selected

  • Entrepreneurs.[Entrepreneur ID]
  • Entrepreneurs.[Division ID]
  • Entrepreneurs.[Pipeline ID]
  • Entrepreneurs.[Process Status ID]
  • Status
  • ProcessStatus.[Step Number]
  • Entrepreneurs.[First Name]
  • Surname

Where Clause

(((Entrepreneurs.[Pipeline ID]) Is Null) AND ((Entrepreneurs.[Process Status ID]

SQL

SELECT Entrepreneurs.[Entrepreneur ID], Entrepreneurs.[Division ID], Entrepreneurs.[Pipeline ID], Entrepreneurs.[Process Status ID], ProcessStatus.Status, ProcessStatus.[Step Number], Entrepreneurs.[First Name], Entrepreneurs.Surname FROM [Entrepreneurs], [ProcessStatus] WHERE (((Entrepreneurs.[Pipeline ID]) Is Null) AND ((Entrepreneurs.[Process Status ID]