Query: Qry SubRpt Product Purple Process
Type: Select
Has Parameters: No
Has Joins: No
Has Subquery: No
Tables Referenced
- Product Purple Process
- Purple Process Steps
- Product
Columns Selected
- [Product Purple Process].[Product ID]
- [Product Purple Process].[Step Number]
- [Purple Process Steps].[Purple Process Step]
- [Product Purple Process].[Conditional on Step]
- [Product Purple Process].[Purple Process Step Details]
SQL
SELECT [Product Purple Process].[Product ID], [Product Purple Process].[Step Number], [Purple Process Steps].[Purple Process Step], [Product Purple Process].[Conditional on Step], [Product Purple Process].[Purple Process Step Details] FROM [Product Purple Process], [Purple Process Steps]