Skip to content

Query: Qry Report SD Alocations Not Notified

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

Tables Referenced

  • Entrepreneur Company Programme Years
  • Principal Project Pillars
  • Principal Projects
  • Entrepreneur Company
  • Entrepreneur
  • Principals
  • Entrepreneur Company Principal Projects

Columns Selected

  • [Principal Project Pillars].[BBBEE Pillar]
  • [Entrepreneur Company Principal Projects].[SA SDM Notified]
  • [Entrepreneur Company Principal Projects].[Date Allocation Created]
  • [Entrepreneur Company].[Company Name]
  • [Principal] & \

Where Clause

((([Principal Project Pillars].[BBBEE Pillar])=\"SD\") AND (([Entrepreneur Compa

Order By

[Entrepreneur Company Principal Projects].[Date Allocation Created]

SQL

SELECT [Principal Project Pillars].[BBBEE Pillar], [Entrepreneur Company Principal Projects].[SA SDM Notified], [Entrepreneur Company Principal Projects].[Date Allocation Created], [Entrepreneur Company].[Company Name], [Principal] & \ FROM [Entrepreneur Company], [Entrepreneur Company Programme Years], [Entrepreneur Company Principal Projects], [Principal Project Pillars], [Principal Projects], [Principals] WHERE ((([Principal Project Pillars].[BBBEE Pillar])=\"SD\") AND (([Entrepreneur Compa