Skip to content

Query: Qry Get Programme Type by Product

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

Tables Referenced

  • BBBEE
  • BBBEE Pillar Lookup
  • Product BBBEE Pillars

Columns Selected

  • [Product BBBEE Pillars].[Product ID]
  • [Product BBBEE Pillars].[BBBEE Pillar]
  • [BBBEE Pillar Lookup].[BBBEE Pillar Description]

SQL

SELECT [Product BBBEE Pillars].[Product ID], [Product BBBEE Pillars].[BBBEE Pillar], [BBBEE Pillar Lookup].[BBBEE Pillar Description] FROM [BBBEE Pillar Lookup], [Product BBBEE Pillars]