Skip to content

Query: Qry Get Division Dist Model and Rec Info by Company

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

Tables Referenced

  • Entrepreneurs

Columns Selected

  • Entrepreneurs.[Entrepreneur Company ID]
  • Entrepreneurs.[Process Status ID]
  • Entrepreneurs.[Division ID]
  • Entrepreneurs.[Distribution Model ID]
  • Entrepreneurs.[Recommended Principal Project ID]
  • Entrepreneurs.[Recommended Product ID]
  • Entrepreneurs.[Pipeline ID]

SQL

SELECT Entrepreneurs.[Entrepreneur Company ID], Entrepreneurs.[Process Status ID], Entrepreneurs.[Division ID], Entrepreneurs.[Distribution Model ID], Entrepreneurs.[Recommended Principal Project ID], Entrepreneurs.[Recommended Product ID], Entrepreneurs.[Pipeline ID] FROM [Entrepreneurs]