Skip to content

Query: Qry Report Writer

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

Tables Referenced

  • Entrepreneurs
  • IndustryLookup
  • Delivery Locations
  • Qry Get Last Programme Year Info for Report Writer
  • Entrepreneur Company
  • CompanyStatus

Columns Selected

  • Entrepreneurs.[Process Status ID]
  • [Entrepreneur Company].[Company Status ID]
  • Status
  • [Entrepreneur Company].[Entrepreneur Company ID]
  • [Entrepreneur Company].[Company Name]
  • [Delivery Locations].[Delivery Location]
  • Industry
  • [Entrepreneur Company].[Brief Description of Business]
  • [Entrepreneur Company].[Average Monthly Turnover]
  • [Entrepreneur Company].[Years in Business]
  • Principal
  • [Qry Get Last Programme Year Info for Report Writer].[Principal Project]
  • Product
  • [Entrepreneur Company].[BEE Level]
  • [Entrepreneur Company].[Percentage Black Owned]
  • [Entrepreneur Company].[Percentage Women Black Owned]
  • [Qry Get Last Programme Year Info for Report Writer].[Total Programme Amount]
  • [Qry Get Last Programme Year Info for Report Writer].[Total Selection Fee]
  • [Qry Get Last Programme Year Info for Report Writer].[BBBEE Pillar]
  • [Qry Get Last Programme Year Info for Report Writer].[Allocated Amount]
  • [Qry Get Last Programme Year Info for Report Writer].[Selection Fee]
  • [Qry Get Last Programme Year Info for Report Writer].[Total Allocated Amt]
  • [Qry Get Last Programme Year Info for Report Writer].[Total Selection Amt]
  • [Qry Get Last Programme Year Info for Report Writer].[Programme Year]
  • [Qry Get Last Programme Year Info for Report Writer].[Company Programme Year Sta
  • [Qry Get Last Programme Year Info for Report Writer].[Programme Year Status]

Where Clause

(((Entrepreneurs.[Process Status ID])=91))

SQL

SELECT Entrepreneurs.[Process Status ID], [Entrepreneur Company].[Company Status ID], CompanyStatus.Status, [Entrepreneur Company].[Entrepreneur Company ID], [Entrepreneur Company].[Company Name], [Delivery Locations].[Delivery Location], IndustryLookup.Industry, [Entrepreneur Company].[Brief Description of Business], [Entrepreneur Company].[Average Monthly Turnover], [Entrepreneur Company].[Years in Business], [Qry Get Last Programme Year Info for Report Writer].Principal, [Qry Get Last Programme Year Info for Report Writer].[Principal Project], [Qry Get Last Programme Year Info for Report Writer].Product, [Entrepreneur Company].[BEE Level], [Entrepreneur Company].[Percentage Black Owned], [Entrepreneur Company].[Percentage Women Black Owned], [Qry Get Last Programme Year Info for Report Writer].[Total Programme Amount], [Qry Get Last Programme Year Info for Report Writer].[Total Selection Fee], [Qry Get Last Programme Year Info for Report Writer].[BBBEE Pillar], [Qry Get Last Programme Year Info for Report Writer].[Allocated Amount], [Qry Get Last Programme Year Info for Report Writer].[Selection Fee], [Qry Get Last Programme Year Info for Report Writer].[Total Allocated Amt], [Qry Get Last Programme Year Info for Report Writer].[Total Selection Amt], [Qry Get Last Programme Year Info for Report Writer].[Programme Year], [Qry Get Last Programme Year Info for Report Writer].[Company Programme Year Sta, [Qry Get Last Programme Year Info for Report Writer].[Programme Year Status] FROM [IndustryLookup], [Entrepreneur Company], [Delivery Locations], [Entrepreneurs], [CompanyStatus], [Qry Get Last Programme Year Info for Report Writer] WHERE (((Entrepreneurs.[Process Status ID])=91))