Skip to content

Query: Qry SubRpt Entrepreneurs in Principal SD Letter

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

Tables Referenced

  • Entrepreneurs

Columns Selected

  • Entrepreneurs.[Entrepreneur Company ID]
  • Province
  • [First Name] & \
  • Entrepreneurs.[Telephone Number]
  • Entrepreneurs.[Second Telephone Number]
  • Entrepreneurs.[Email Address]
  • Entrepreneurs.[Alternative Email Address]

SQL

SELECT Entrepreneurs.[Entrepreneur Company ID], Entrepreneurs.Province, [First Name] & \, Entrepreneurs.[Telephone Number], Entrepreneurs.[Second Telephone Number], Entrepreneurs.[Email Address], Entrepreneurs.[Alternative Email Address] FROM [Entrepreneurs]