Skip to content

Query: Qry Product Distribution Model List

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

Tables Referenced

  • Products
  • Product Distribution Models
  • Distribution Models

Columns Selected

  • Products.[Product ID]
  • [Product Distribution Models].[Product Distribution Model ID]
  • Product
  • [Distribution Models].[Distribution Model]

SQL

SELECT Products.[Product ID], [Product Distribution Models].[Product Distribution Model ID], Products.Product, [Distribution Models].[Distribution Model] FROM [Products], [Distribution Models], [Product Distribution Models]