Skip to content

Query: Qry Rubric Metrics NOT in the List

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

Tables Referenced

  • SubQry Rubric Metrics NOT in the List
  • Metrics
  • SubQry

Columns Selected

  • Metrics.[Metric ID]
  • Metric
  • Metrics.[Metric Description]
  • Metrics.[Sort Order]

Where Clause

((([SubQry Rubric Metrics NOT in the List].[Metric ID]) Is Null))

Order By

Metrics.[Sort Order]

SQL

SELECT Metrics.[Metric ID], Metrics.Metric, Metrics.[Metric Description], Metrics.[Sort Order] FROM [SubQry Rubric Metrics NOT in the List], [Metrics] WHERE ((([SubQry Rubric Metrics NOT in the List].[Metric ID]) Is Null))