Query: Qry Get Companies for Principal Spend Tracking Report

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

Tables Referenced

Entrepreneur
Entrepreneur Company
Principal Project Pillars
Entrepreneur Company Programme Years
Entrepreneur Company Principal Projects
Entrepreneurs

Columns Selected

[Principal Project Pillars].[Principal Project ID]
[Entrepreneur Company].[Entrepreneur Company ID]
[Entrepreneur Company].[Company Name]
[Entrepreneur Company Principal Projects].[Entrepreneur Company Principal Projec
[Entrepreneur Company Programme Years].[Contract Start Date]

Where Clause

((([Entrepreneur Company Programme Years].[Company Programme Year Status ID])=1)

Order By

[Principal Project Pillars].[Principal Project ID], [Entrepreneur Company].[Company Name], [Entrepreneur Company Principal Projects].[Entrepreneur Company Principal Projec

SQL

SELECT [Principal Project Pillars].[Principal Project ID], [Entrepreneur Company].[Entrepreneur Company ID], [Entrepreneur Company].[Company Name], [Entrepreneur Company Principal Projects].[Entrepreneur Company Principal Projec, [Entrepreneur Company Programme Years].[Contract Start Date] FROM [Entrepreneur Company Programme Years], [Entrepreneur Company Principal Projects], [Principal Project Pillars], [Entrepreneur Company], [Entrepreneurs] WHERE ((([Entrepreneur Company Programme Years].[Company Programme Year Status ID])=1)