Skip to content

Query: Qry Report Allocation Export Graduated Companies

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

Tables Referenced

  • Principal Project Pillars
  • Entrepreneur Company Principal Projects
  • CompanyStatus
  • Principal Projects
  • SubQry Get Last Programme Year for Exited Companies
  • Products
  • CompanyProgrammeYearStatus
  • Entrepreneur Company
  • Qry Sum Total Allocated Amt by Company
  • Principals
  • IndustryLookup
  • Qry Sum Total Spend by Principal Project
  • Entrepreneur Company Programme Years
  • Entrepreneurs
  • Delivery Locations

Columns Selected

  • Entrepreneurs.[Entrepreneur ID]
  • [Entrepreneur Company].[Entrepreneur Company ID]
  • Entrepreneurs.[Division ID]
  • [Entrepreneur Company].[Company Status ID]
  • [Entrepreneur Company Programme Years].[Company Programme Year Status ID]
  • CompanyProgrammeYearStatus.[Programme Year Status]
  • [Entrepreneur Company Programme Years].[Date Status Changed]
  • [Entrepreneur Company Programme Years].[Contract Start Date]

Where Clause

(((Entrepreneurs.[Division ID])<>3) AND (([Entrepreneur Company Programme Years]

Order By

Entrepreneurs.[Allocation ID], [First Name] & \

SQL

SELECT Entrepreneurs.[Entrepreneur ID], [Entrepreneur Company].[Entrepreneur Company ID], Entrepreneurs.[Division ID], [Entrepreneur Company].[Company Status ID], [Entrepreneur Company Programme Years].[Company Programme Year Status ID], CompanyProgrammeYearStatus.[Programme Year Status], [Entrepreneur Company Programme Years].[Date Status Changed], [Entrepreneur Company Programme Years].[Contract Start Date] FROM [IndustryLookup], [Principal Projects], [Principals], [Qry Sum Total Spend by Principal Project], [Entrepreneurs], [Products], [Principal Project Pillars], [Entrepreneur Company], [Delivery Locations], [SubQry Get Last Programme Year for Exited Companies], [Entrepreneur Company Programme Years], [Entrepreneur Company Principal Projects], [CompanyStatus], [CompanyProgrammeYearStatus], [Qry Sum Total Allocated Amt by Company] WHERE (((Entrepreneurs.[Division ID])<>3) AND (([Entrepreneur Company Programme Years]