Skip to content

Query: Qry Get Entrepreneur Recommended Information

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

Tables Referenced

  • Lead Types
  • Principal Projects
  • Products
  • Principals
  • Entrepreneurs

Columns Selected

  • Entrepreneurs.[Entrepreneur Company ID]
  • [Principal] & \
  • Entrepreneurs.[Recommended BBBEE Pillar]
  • Product
  • Entrepreneurs.[Division ID]
  • Entrepreneurs.[Distribution Model ID]

SQL

SELECT Entrepreneurs.[Entrepreneur Company ID], [Principal] & \, Entrepreneurs.[Recommended BBBEE Pillar], Products.Product, Entrepreneurs.[Division ID], Entrepreneurs.[Distribution Model ID] FROM [Entrepreneurs], [Principal Projects], [Principals], [Products], [Lead Types]