Skip to content

Query: Qry Entrepreneur Company Sub Products

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

Tables Referenced

  • Entrepreneur
  • Sub Products
  • Principal Project Pillar Sub Products
  • Entrepreneur Company Sub Products

Columns Selected

  • [Entrepreneur Company Sub Products].[Entrepreneur Company Sub Product ID]
  • [Entrepreneur Company Sub Products].[Entrepreneur Company ID]
  • [Sub Products].[BBBEE Pillar]
  • [Sub Products].[Sub Product]
  • [Principal Project Pillar Sub Products].[Sponsorship Amount]
  • [Principal Project Pillar Sub Products].[Number of Entrepreneurs]
  • [Entrepreneur Company Sub Products].[Sub Product Allocated Amount]

SQL

SELECT [Entrepreneur Company Sub Products].[Entrepreneur Company Sub Product ID], [Entrepreneur Company Sub Products].[Entrepreneur Company ID], [Sub Products].[BBBEE Pillar], [Sub Products].[Sub Product], [Principal Project Pillar Sub Products].[Sponsorship Amount], [Principal Project Pillar Sub Products].[Number of Entrepreneurs], [Entrepreneur Company Sub Products].[Sub Product Allocated Amount] FROM [Entrepreneur Company Sub Products], [Principal Project Pillar Sub Products], [Sub Products]