Skip to content

Query: Qry Edit Purple Panelists Main Form

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

Tables Referenced

  • Purple Panelists
  • Purple Panels
  • Purple

Columns Selected

  • [Purple Panels].[Changed Rubric Switch]
  • [Purple Panels].[Purple Panel ID]
  • [Purple Panels].[Rubric ID]
  • [Purple Panels].[Entrepreneur Company ID]
  • [Purple Panelists].[Purple Panelist ID]
  • [Purple Panels].[Purple Panel Status ID]
  • [Purple Panels].[Purple Panel Date]
  • [Purple Panelists].[Purple Panelist Total Score]
  • [Purple Panelists].[Possible Total Score]
  • [Purple Panelists].[Purple Panelist]
  • [Purple Panelists].[Business Area]
  • Submitted
  • [Purple Panels].[Recommended Product]
  • Questions
  • Convener

Order By

[Purple Panels].[Purple Panel Date], [Purple Panelists].[Purple Panelist]

SQL

SELECT [Purple Panels].[Changed Rubric Switch], [Purple Panels].[Purple Panel ID], [Purple Panels].[Rubric ID], [Purple Panels].[Entrepreneur Company ID], [Purple Panelists].[Purple Panelist ID], [Purple Panels].[Purple Panel Status ID], [Purple Panels].[Purple Panel Date], [Purple Panelists].[Purple Panelist Total Score], [Purple Panelists].[Possible Total Score], [Purple Panelists].[Purple Panelist], [Purple Panelists].[Business Area], [Purple Panelists].Submitted, [Purple Panels].[Recommended Product], [Purple Panelists].Questions, [Purple Panelists].Convener FROM [Purple Panels], [Purple Panelists]