Skip to content

Query: Qry SubRpt Product Divisions

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

Tables Referenced

  • Product Divisions
  • Divisions

Columns Selected

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

SQL

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