Skip to content

Query: Qry Report Part Sponsorship

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

Tables Referenced

  • SubQry
  • SubQry Rpt Part Sponsorship

Columns Selected

  • [SubQry Rpt Part Sponsorship].[Entrepreneur Company ID]
  • [SubQry Rpt Part Sponsorship].[Company Programme Year Status ID]
  • [SubQry Rpt Part Sponsorship].[Programme Year Status]
  • [SubQry Rpt Part Sponsorship].[Company Status ID]
  • [SubQry Rpt Part Sponsorship].[Company Status]
  • [SubQry Rpt Part Sponsorship].[Delivery Location]
  • [SubQry Rpt Part Sponsorship].[Company Name]
  • Industry
  • [SubQry Rpt Part Sponsorship].[Percentage Black Owned]
  • [SubQry Rpt Part Sponsorship].[Percentage Women Black Owned]
  • [SubQry Rpt Part Sponsorship].[Brief Description of Business]
  • Product
  • [SubQry Rpt Part Sponsorship].[Programme Year]

SQL

SELECT [SubQry Rpt Part Sponsorship].[Entrepreneur Company ID], [SubQry Rpt Part Sponsorship].[Company Programme Year Status ID], [SubQry Rpt Part Sponsorship].[Programme Year Status], [SubQry Rpt Part Sponsorship].[Company Status ID], [SubQry Rpt Part Sponsorship].[Company Status], [SubQry Rpt Part Sponsorship].[Delivery Location], [SubQry Rpt Part Sponsorship].[Company Name], [SubQry Rpt Part Sponsorship].Industry, [SubQry Rpt Part Sponsorship].[Percentage Black Owned], [SubQry Rpt Part Sponsorship].[Percentage Women Black Owned], [SubQry Rpt Part Sponsorship].[Brief Description of Business], [SubQry Rpt Part Sponsorship].Product, [SubQry Rpt Part Sponsorship].[Programme Year] FROM [SubQry Rpt Part Sponsorship]