Skip to content

Query: Qry Entrepreneur List Company Commodity

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

Tables Referenced

  • vwPurpleEntrepreneurListCompanyCommodity

Columns Selected

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

SQL

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