Skip to content

Query: Qry SubRpt Entrepreneur Profile Merge Data

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

Tables Referenced

  • Products
  • ProcessStatus
  • Entrepreneurs
  • Divisions

Columns Selected

  • Entrepreneurs.[Entrepreneur Company ID]
  • Entrepreneurs.[Entrepreneur ID]
  • [First Name] & \
  • Province
  • Entrepreneurs.[Recommended BBBEE Pillar]
  • Product

Where Clause

(((Entrepreneurs.[Profile Created])=False) AND ((Entrepreneurs.[Division ID])=1)

SQL

SELECT Entrepreneurs.[Entrepreneur Company ID], Entrepreneurs.[Entrepreneur ID], [First Name] & \, Entrepreneurs.Province, Entrepreneurs.[Recommended BBBEE Pillar], Products.Product FROM [Entrepreneurs], [ProcessStatus], [Products], [Divisions] WHERE (((Entrepreneurs.[Profile Created])=False) AND ((Entrepreneurs.[Division ID])=1)