Query: Qry Job Code Regret Reason List

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

Tables Referenced

• Regret Reasons
• Job Code Regret Reasons
• Regret

Columns Selected

• [Job Code Regret Reasons].[Job Code Regret Reason ID]
• [Job Code Regret Reasons].[Job ID]
• [Job Code Regret Reasons].[Regret Reason ID]
• [Regret Reasons].[Regret Reason]
• [Regret Reasons].[Sort Order]
• Active

SQL

SELECT [Job Code Regret Reasons].[Job Code Regret Reason ID], [Job Code Regret Reasons].[Job ID], [Job Code Regret Reasons].[Regret Reason ID], [Regret Reasons].[Regret Reason], [Regret Reasons].[Sort Order], [Regret Reasons].Active FROM [Regret Reasons], [Job Code Regret Reasons]