Skip to content

Query: Qry Get Recommended Product by Company

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

Tables Referenced

  • Products
  • Entrepreneurs

Columns Selected

  • Entrepreneurs.[Entrepreneur Company ID]
  • Product
  • Entrepreneurs.[Division ID]
  • Entrepreneurs.[Distribution Model ID]

SQL

SELECT Entrepreneurs.[Entrepreneur Company ID], Products.Product, Entrepreneurs.[Division ID], Entrepreneurs.[Distribution Model ID] FROM [Entrepreneurs], [Products]