Skip to content

Query: Qry Company Principal Project List

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

Tables Referenced

  • vwGarnetCompanyPrincipalProjectList
  • vwGarnetGetEPReadyforAllocationInfobyCompany

Columns Selected

  • vwGarnetCompanyPrincipalProjectList.[Entrepreneur Company ID]
  • vwGarnetCompanyPrincipalProjectList.[Principal Project ID]
  • vwGarnetCompanyPrincipalProjectList.[Company Name]
  • vwGarnetCompanyPrincipalProjectList.[Company Delivery Location ID]
  • vwGarnetCompanyPrincipalProjectList.[Delivery Location]
  • vwGarnetCompanyPrincipalProjectList.[Company Status ID]
  • vwGarnetCompanyPrincipalProjectList.[Company Programme Year Status ID]
  • Status
  • vwGarnetCompanyPrincipalProjectList.[Programme Year Status]
  • [Principal] & ' - ' & [Project Name]
  • vwGarnetCompanyPrincipalProjectList.[Sort Order]
  • vwGarnetCompanyPrincipalProjectList.[Year Status Change]
  • vwGarnetCompanyPrincipalProjectList.[Status Change]
  • vwGarnetCompanyPrincipalProjectList.[Ignition Date]
  • Product
  • vwGarnetCompanyPrincipalProjectList.[Programme Year]
  • Industry
  • vwGarnetCompanyPrincipalProjectList.[Contract Start Date]

SQL

SELECT vwGarnetCompanyPrincipalProjectList.[Entrepreneur Company ID], vwGarnetCompanyPrincipalProjectList.[Principal Project ID], vwGarnetCompanyPrincipalProjectList.[Company Name], vwGarnetCompanyPrincipalProjectList.[Company Delivery Location ID], vwGarnetCompanyPrincipalProjectList.[Delivery Location], vwGarnetCompanyPrincipalProjectList.[Company Status ID], vwGarnetCompanyPrincipalProjectList.[Company Programme Year Status ID], vwGarnetCompanyPrincipalProjectList.Status, vwGarnetCompanyPrincipalProjectList.[Programme Year Status], [Principal] & ' - ' & [Project Name], vwGarnetCompanyPrincipalProjectList.[Sort Order], vwGarnetCompanyPrincipalProjectList.[Year Status Change], vwGarnetCompanyPrincipalProjectList.[Status Change], vwGarnetCompanyPrincipalProjectList.[Ignition Date], vwGarnetCompanyPrincipalProjectList.Product, vwGarnetCompanyPrincipalProjectList.[Programme Year], vwGarnetCompanyPrincipalProjectList.Industry, vwGarnetCompanyPrincipalProjectList.[Contract Start Date] FROM [vwGarnetGetEPReadyforAllocationInfobyCompany], [vwGarnetCompanyPrincipalProjectList]