Skip to content

Query: Qry SubRpt Product Principal Reports Sent

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

Tables Referenced

  • Product
  • Product Principal Reports Sent
  • Principal Reports Sent Lookup

Columns Selected

  • [Product Principal Reports Sent].[Product ID]
  • [Principal Reports Sent Lookup].[Principal Reports Sent]
  • [Principal Reports Sent Lookup].[Principal Reports Sent Detail]
  • [Principal Reports Sent Lookup].[Sort Order]

SQL

SELECT [Product Principal Reports Sent].[Product ID], [Principal Reports Sent Lookup].[Principal Reports Sent], [Principal Reports Sent Lookup].[Principal Reports Sent Detail], [Principal Reports Sent Lookup].[Sort Order] FROM [Product Principal Reports Sent], [Principal Reports Sent Lookup]