Skip to content

Query: JB Qry Compression Rubric

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

Tables Referenced

  • Rubric Metric Templates
  • Rubrics
  • Metrics

Columns Selected

  • Rubrics.[Rubric ID]
  • [Rubric Metric Templates].[Rubric Metric Template ID]
  • [Rubric Metric Templates].[Metric ID]
  • Rubric
  • Metric
  • Metrics.[Metric Description]
  • Metrics.[Sort Order]

Where Clause

(((Rubrics.[Rubric ID])=5))

Order By

Metrics.[Sort Order]

SQL

SELECT Rubrics.[Rubric ID], [Rubric Metric Templates].[Rubric Metric Template ID], [Rubric Metric Templates].[Metric ID], Rubrics.Rubric, Metrics.Metric, Metrics.[Metric Description], Metrics.[Sort Order] FROM [Rubrics], [Rubric Metric Templates], [Metrics] WHERE (((Rubrics.[Rubric ID])=5))