Skip to content

Query: Qry Count CV Not Suitable Reasons by Position

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

Tables Referenced

  • Applications
  • CV Not Suitable Reasons

Columns Selected

  • Applications.[Position ID]
  • Applications.[CV Not Suitable Reason ID]
  • [CV Not Suitable Reasons].[CV Not Suitable Reason]
  • [CV Not Suitable Reasons].[Sort Order]
  • Count(Applications.[Application ID])

Where Clause

(((Applications.[Application Status ID])=30))

SQL

SELECT Applications.[Position ID], Applications.[CV Not Suitable Reason ID], [CV Not Suitable Reasons].[CV Not Suitable Reason], [CV Not Suitable Reasons].[Sort Order], Count(Applications.[Application ID]) FROM [Applications], [CV Not Suitable Reasons] WHERE (((Applications.[Application Status ID])=30))