Skip to content

Query: Qry Product Principal Reports Structure

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

Tables Referenced

  • Product Principal Reports Structure
  • Principal Reports Structure Lookup
  • Product

Columns Selected

  • [Product Principal Reports Structure].[Product Principal Reports Structure ID]
  • [Product Principal Reports Structure].[Product ID]
  • [Principal Reports Structure Lookup].[Principal Reports Structure Category]
  • [Principal Reports Structure Lookup].[Principal Reports Structure Item]
  • [Principal Reports Structure Lookup].[Sort Order]

SQL

SELECT [Product Principal Reports Structure].[Product Principal Reports Structure ID], [Product Principal Reports Structure].[Product ID], [Principal Reports Structure Lookup].[Principal Reports Structure Category], [Principal Reports Structure Lookup].[Principal Reports Structure Item], [Principal Reports Structure Lookup].[Sort Order] FROM [Product Principal Reports Structure], [Principal Reports Structure Lookup]