Skip to content

Query: Qry Get Current Contract Info by Company

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

Tables Referenced

  • Qry
  • Qry Sum Total Allocated Amt by Company
  • vwPurpleGetCurrentContractInfobyCompany

Columns Selected

  • vwPurpleGetCurrentContractInfobyCompany.[Entrepreneur Company ID]
  • vwPurpleGetCurrentContractInfobyCompany.[Division ID]
  • vwPurpleGetCurrentContractInfobyCompany.[Programme Year]
  • vwPurpleGetCurrentContractInfobyCompany.[Principal Project ID]
  • Principal
  • [Principal] & \
  • vwPurpleGetCurrentContractInfobyCompany.[Product ID]
  • Product
  • vwPurpleGetCurrentContractInfobyCompany.[Contract Start Date]

SQL

SELECT vwPurpleGetCurrentContractInfobyCompany.[Entrepreneur Company ID], vwPurpleGetCurrentContractInfobyCompany.[Division ID], vwPurpleGetCurrentContractInfobyCompany.[Programme Year], vwPurpleGetCurrentContractInfobyCompany.[Principal Project ID], vwPurpleGetCurrentContractInfobyCompany.Principal, [Principal] & \, vwPurpleGetCurrentContractInfobyCompany.[Product ID], vwPurpleGetCurrentContractInfobyCompany.Product, vwPurpleGetCurrentContractInfobyCompany.[Contract Start Date] FROM [Qry Sum Total Allocated Amt by Company], [vwPurpleGetCurrentContractInfobyCompany]