Skip to content

Query: Qry Company Entrepreneur Ignition List

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

Tables Referenced

  • vwGarnetCompanyEntrepreneurIgnitionList

Columns Selected

  • vwGarnetCompanyEntrepreneurIgnitionList.[Entrepreneur Company ID]
  • [First Name] & \
  • vwGarnetCompanyEntrepreneurIgnitionList.[Company Name]
  • vwGarnetCompanyEntrepreneurIgnitionList.[Delivery Location]
  • Status
  • [Principal] & ' - ' & [Project Name]
  • Product
  • vwGarnetCompanyEntrepreneurIgnitionList.[Programme Year]
  • vwGarnetCompanyEntrepreneurIgnitionList.[Ignition Date]
  • Industry
  • vwGarnetCompanyEntrepreneurIgnitionList.[Committment Fee]
  • vwGarnetCompanyEntrepreneurIgnitionList.[Date Contract Signed]
  • OwnedBy
  • vwGarnetCompanyEntrepreneurIgnitionList.[Email Address]
  • vwGarnetCompanyEntrepreneurIgnitionList.[Telephone Number]
  • vwGarnetCompanyEntrepreneurIgnitionList.[Second Telephone Number]

SQL

SELECT vwGarnetCompanyEntrepreneurIgnitionList.[Entrepreneur Company ID], [First Name] & \, vwGarnetCompanyEntrepreneurIgnitionList.[Company Name], vwGarnetCompanyEntrepreneurIgnitionList.[Delivery Location], vwGarnetCompanyEntrepreneurIgnitionList.Status, [Principal] & ' - ' & [Project Name], vwGarnetCompanyEntrepreneurIgnitionList.Product, vwGarnetCompanyEntrepreneurIgnitionList.[Programme Year], vwGarnetCompanyEntrepreneurIgnitionList.[Ignition Date], vwGarnetCompanyEntrepreneurIgnitionList.Industry, vwGarnetCompanyEntrepreneurIgnitionList.[Committment Fee], vwGarnetCompanyEntrepreneurIgnitionList.[Date Contract Signed], vwGarnetCompanyEntrepreneurIgnitionList.OwnedBy, vwGarnetCompanyEntrepreneurIgnitionList.[Email Address], vwGarnetCompanyEntrepreneurIgnitionList.[Telephone Number], vwGarnetCompanyEntrepreneurIgnitionList.[Second Telephone Number] FROM [vwGarnetCompanyEntrepreneurIgnitionList]