Skip to content

Query: Qry Product Principal Reports Structure NOT Included

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

Tables Referenced

  • SubQry Product Principal Reports Structure NOT Included
  • SubQry
  • Principal Reports Structure Lookup

Columns Selected

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

Where Clause

((([SubQry Product Principal Reports Structure NOT Included].[nPrincipal Reports

SQL

SELECT [Principal Reports Structure Lookup].[Principal Reports Structure ID], [Principal Reports Structure Lookup].[Principal Reports Structure Category], [Principal Reports Structure Lookup].[Principal Reports Structure Item], [Principal Reports Structure Lookup].[Sort Order] FROM [SubQry Product Principal Reports Structure NOT Included], [Principal Reports Structure Lookup] WHERE ((([SubQry Product Principal Reports Structure NOT Included].[nPrincipal Reports