Skip to content

Query: Qry Entrepreneur Company VA Pack Audit Detail Not in Config List

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

Tables Referenced

  • Qry Entrepreneur Company VA Pack Audit Detail Config List
  • Qry
  • VA Pack Audit Score Template

Columns Selected

  • [VA Pack Audit Score Template].[VA Pack Audit Score Template ID]
  • [VA Pack Audit Score Template].[VA Pack Audit Score Item]
  • [VA Pack Audit Score Template].[VA Pack Audit Possible Score]
  • [VA Pack Audit Score Template].[VA Pack Audit Score Sort Order]

Where Clause

((([Qry Entrepreneur Company VA Pack Audit Detail Config List].[VA Pack Audit Sc

Order By

[VA Pack Audit Score Template].[VA Pack Audit Score Sort Order]

SQL

SELECT [VA Pack Audit Score Template].[VA Pack Audit Score Template ID], [VA Pack Audit Score Template].[VA Pack Audit Score Item], [VA Pack Audit Score Template].[VA Pack Audit Possible Score], [VA Pack Audit Score Template].[VA Pack Audit Score Sort Order] FROM [Qry Entrepreneur Company VA Pack Audit Detail Config List], [VA Pack Audit Score Template] WHERE ((([Qry Entrepreneur Company VA Pack Audit Detail Config List].[VA Pack Audit Sc