Skip to content

Query: Qry Entrepreneur List Current Principal Projects

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

Tables Referenced

  • vwPurpleEntrepreneurListCurrentPrincipalProjects
  • vwPurpleGetCurrentContractInfobyCompany

Columns Selected

  • vwPurpleEntrepreneurListCurrentPrincipalProjects.[Process Status ID]
  • vwPurpleEntrepreneurListCurrentPrincipalProjects.[Entrepreneur Company ID]
  • vwPurpleEntrepreneurListCurrentPrincipalProjects.[Entrepreneur ID]
  • [First Name] & \
  • vwPurpleEntrepreneurListCurrentPrincipalProjects.[Company Name]
  • vwPurpleEntrepreneurListCurrentPrincipalProjects.[Company Status ID]
  • vwPurpleEntrepreneurListCurrentPrincipalProjects.[Date Status Changed]
  • vwPurpleEntrepreneurListCurrentPrincipalProjects.[Status Modified By]
  • Status
  • vwPurpleEntrepreneurListCurrentPrincipalProjects.[Lead Type]
  • Province
  • Industry
  • Division
  • vwPurpleEntrepreneurListCurrentPrincipalProjects.[Delivery Location]
  • OwnedBy
  • vwPurpleEntrepreneurListCurrentPrincipalProjects.[Date Record Created]
  • vwPurpleEntrepreneurListCurrentPrincipalProjects.[Date Modified]
  • vwPurpleEntrepreneurListCurrentPrincipalProjects.[Last Modified By]
  • [vwPurpleEntrepreneurListCurrentPrincipalProjects].[Principal] & \
  • vwPurpleEntrepreneurListCurrentPrincipalProjects.[Process Date]
  • IIf([Ring Fencing]=True,\
  • vwPurpleEntrepreneurListCurrentPrincipalProjects.[Recommended Product]
  • vwPurpleEntrepreneurListCurrentPrincipalProjects.[Email Address]
  • vwPurpleGetCurrentContractInfobyCompany.[Date Contract Signed]
  • vwPurpleGetCurrentContractInfobyCompany.[VA Packs Delivered]
  • vwPurpleGetCurrentContractInfobyCompany.[Contract Start Date]

Order By

[First Name] & \

SQL

SELECT vwPurpleEntrepreneurListCurrentPrincipalProjects.[Process Status ID], vwPurpleEntrepreneurListCurrentPrincipalProjects.[Entrepreneur Company ID], vwPurpleEntrepreneurListCurrentPrincipalProjects.[Entrepreneur ID], [First Name] & \, vwPurpleEntrepreneurListCurrentPrincipalProjects.[Company Name], vwPurpleEntrepreneurListCurrentPrincipalProjects.[Company Status ID], vwPurpleEntrepreneurListCurrentPrincipalProjects.[Date Status Changed], vwPurpleEntrepreneurListCurrentPrincipalProjects.[Status Modified By], vwPurpleEntrepreneurListCurrentPrincipalProjects.Status, vwPurpleEntrepreneurListCurrentPrincipalProjects.[Lead Type], vwPurpleEntrepreneurListCurrentPrincipalProjects.Province, vwPurpleEntrepreneurListCurrentPrincipalProjects.Industry, vwPurpleEntrepreneurListCurrentPrincipalProjects.Division, vwPurpleEntrepreneurListCurrentPrincipalProjects.[Delivery Location], vwPurpleEntrepreneurListCurrentPrincipalProjects.OwnedBy, vwPurpleEntrepreneurListCurrentPrincipalProjects.[Date Record Created], vwPurpleEntrepreneurListCurrentPrincipalProjects.[Date Modified], vwPurpleEntrepreneurListCurrentPrincipalProjects.[Last Modified By], [vwPurpleEntrepreneurListCurrentPrincipalProjects].[Principal] & \, vwPurpleEntrepreneurListCurrentPrincipalProjects.[Process Date], IIf([Ring Fencing]=True,\, vwPurpleEntrepreneurListCurrentPrincipalProjects.[Recommended Product], vwPurpleEntrepreneurListCurrentPrincipalProjects.[Email Address], vwPurpleGetCurrentContractInfobyCompany.[Date Contract Signed], vwPurpleGetCurrentContractInfobyCompany.[VA Packs Delivered], vwPurpleGetCurrentContractInfobyCompany.[Contract Start Date] FROM [vwPurpleGetCurrentContractInfobyCompany], [vwPurpleEntrepreneurListCurrentPrincipalProjects]