Skip to content

Query: Qry Principal Project Sub Products

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

Tables Referenced

  • Principal Project Pillar Sub Products
  • Principal Project Pillars
  • Principal Projects
  • Principals
  • Sub Products

Columns Selected

  • [Principal Project Pillar Sub Products].[Principal Project Pillar Sub Product ID
  • [Principal Project Pillars].[BBBEE Pillar]
  • [Sub Products].[Sub Product]
  • [Principal Project Pillar Sub Products].[Sponsorship Amount]
  • [Principal Project Pillar Sub Products].[Number of Entrepreneurs]
  • Frequency

SQL

SELECT [Principal Project Pillar Sub Products].[Principal Project Pillar Sub Product ID, [Principal Project Pillars].[BBBEE Pillar], [Sub Products].[Sub Product], [Principal Project Pillar Sub Products].[Sponsorship Amount], [Principal Project Pillar Sub Products].[Number of Entrepreneurs], [Principal Project Pillar Sub Products].Frequency FROM [Principals], [Principal Projects], [Principal Project Pillars], [Principal Project Pillar Sub Products], [Sub Products]