Skip to content

Query: Qry Product Division List

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

Tables Referenced

  • Products
  • Product Divisions
  • Divisions

Columns Selected

  • Products.[Product ID]
  • [Product Divisions].[Product Division ID]
  • Product
  • Division

SQL

SELECT Products.[Product ID], [Product Divisions].[Product Division ID], Products.Product, Divisions.Division FROM [Products], [Product Divisions], [Divisions]