Skip to content

Query: Qry Entrepreneur Company List Principal Projects

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

Tables Referenced

  • vwPurpleEntrepreneurCompanyListPrincipalProjects

Columns Selected

  • vwPurpleEntrepreneurCompanyListPrincipalProjects.[Entrepreneur ID]
  • [First Name] & \
  • vwPurpleEntrepreneurCompanyListPrincipalProjects.[Email Address]
  • vwPurpleEntrepreneurCompanyListPrincipalProjects.[Delivery Location]
  • vwPurpleEntrepreneurCompanyListPrincipalProjects.[Entrepreneur Company ID]
  • vwPurpleEntrepreneurCompanyListPrincipalProjects.[Company Name]
  • vwPurpleEntrepreneurCompanyListPrincipalProjects.[Company Status ID]
  • Status
  • vwPurpleEntrepreneurCompanyListPrincipalProjects.[Sort Order]
  • vwPurpleEntrepreneurCompanyListPrincipalProjects.[Status Modified By]
  • vwPurpleEntrepreneurCompanyListPrincipalProjects.[Date Status Changed]
  • OwnedBy
  • Product
  • Industry
  • vwPurpleEntrepreneurCompanyListPrincipalProjects.[Recommended Product]
  • vwPurpleEntrepreneurCompanyListPrincipalProjects.[Programme Year]
  • vwPurpleEntrepreneurCompanyListPrincipalProjects.[Contract Start Date]

SQL

SELECT vwPurpleEntrepreneurCompanyListPrincipalProjects.[Entrepreneur ID], [First Name] & \, vwPurpleEntrepreneurCompanyListPrincipalProjects.[Email Address], vwPurpleEntrepreneurCompanyListPrincipalProjects.[Delivery Location], vwPurpleEntrepreneurCompanyListPrincipalProjects.[Entrepreneur Company ID], vwPurpleEntrepreneurCompanyListPrincipalProjects.[Company Name], vwPurpleEntrepreneurCompanyListPrincipalProjects.[Company Status ID], vwPurpleEntrepreneurCompanyListPrincipalProjects.Status, vwPurpleEntrepreneurCompanyListPrincipalProjects.[Sort Order], vwPurpleEntrepreneurCompanyListPrincipalProjects.[Status Modified By], vwPurpleEntrepreneurCompanyListPrincipalProjects.[Date Status Changed], vwPurpleEntrepreneurCompanyListPrincipalProjects.OwnedBy, vwPurpleEntrepreneurCompanyListPrincipalProjects.Product, vwPurpleEntrepreneurCompanyListPrincipalProjects.Industry, vwPurpleEntrepreneurCompanyListPrincipalProjects.[Recommended Product], vwPurpleEntrepreneurCompanyListPrincipalProjects.[Programme Year], vwPurpleEntrepreneurCompanyListPrincipalProjects.[Contract Start Date] FROM [vwPurpleEntrepreneurCompanyListPrincipalProjects]