Skip to content

Query: Qry Entrepreneur List

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

Tables Referenced

  • vwPurpleEntrepreneurList

Columns Selected

  • vwPurpleEntrepreneurList.[Entrepreneur ID]
  • vwPurpleEntrepreneurList.[Company Status ID]
  • vwPurpleEntrepreneurList.[Student ID]
  • [First Name] & \
  • vwPurpleEntrepreneurList.[Company Name]
  • Step
  • Status
  • vwPurpleEntrepreneurList.[Sort Order]
  • vwPurpleEntrepreneurList.[Date Status Changed]
  • vwPurpleEntrepreneurList.[Lead Type]
  • Province
  • Industry
  • Division
  • vwPurpleEntrepreneurList.[Delivery Location]
  • OwnedBy
  • vwPurpleEntrepreneurList.[Process Status ID]
  • vwPurpleEntrepreneurList.[Date Record Created]
  • vwPurpleEntrepreneurList.[Date Modified]
  • vwPurpleEntrepreneurList.[Last Modified By]
  • [Principal] & \
  • vwPurpleEntrepreneurList.[Process Date]
  • vwPurpleEntrepreneurList.[Recommended Product]
  • vwPurpleEntrepreneurList.[Email Address]

SQL

SELECT vwPurpleEntrepreneurList.[Entrepreneur ID], vwPurpleEntrepreneurList.[Company Status ID], vwPurpleEntrepreneurList.[Student ID], [First Name] & \, vwPurpleEntrepreneurList.[Company Name], vwPurpleEntrepreneurList.Step, vwPurpleEntrepreneurList.Status, vwPurpleEntrepreneurList.[Sort Order], vwPurpleEntrepreneurList.[Date Status Changed], vwPurpleEntrepreneurList.[Lead Type], vwPurpleEntrepreneurList.Province, vwPurpleEntrepreneurList.Industry, vwPurpleEntrepreneurList.Division, vwPurpleEntrepreneurList.[Delivery Location], vwPurpleEntrepreneurList.OwnedBy, vwPurpleEntrepreneurList.[Process Status ID], vwPurpleEntrepreneurList.[Date Record Created], vwPurpleEntrepreneurList.[Date Modified], vwPurpleEntrepreneurList.[Last Modified By], [Principal] & \, vwPurpleEntrepreneurList.[Process Date], vwPurpleEntrepreneurList.[Recommended Product], vwPurpleEntrepreneurList.[Email Address] FROM [vwPurpleEntrepreneurList]