Skip to content

Query: Qry Get Entrepreneur Recommended Information

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

Tables Referenced

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

Columns Selected

  • Entrepreneurs.[Entrepreneur Company ID]
  • [First Name] & \
  • [Principal] & \
  • Entrepreneurs.[Recommended BBBEE Pillar]
  • Product
  • Entrepreneurs.[Division ID]
  • Entrepreneurs.[Distribution Model ID]
  • [Lead Types].[Lead Type]
  • [Lead Types].[Lead Source]

SQL

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