Skip to content

Query: Qry Get Unused Metrics by Purple Panelist

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

Tables Referenced

  • Purple Panelists Scores
  • Rubric Metric Templates
  • Purple

Columns Selected

  • [Purple Panelists Scores].[Purple Panelist Score ID]
  • [Purple Panelists Scores].[Purple Panelist ID]
  • [Rubric Metric Templates].[Metric ID]
  • [Purple Panelists Scores].[Purple Panelist Score]
  • Unused

Where Clause

((([Purple Panelists Scores].Unused)=True))

SQL

SELECT [Purple Panelists Scores].[Purple Panelist Score ID], [Purple Panelists Scores].[Purple Panelist ID], [Rubric Metric Templates].[Metric ID], [Purple Panelists Scores].[Purple Panelist Score], [Purple Panelists Scores].Unused FROM [Purple Panelists Scores], [Rubric Metric Templates] WHERE ((([Purple Panelists Scores].Unused)=True))