Generated SQL Query

This is the SQL Query String that has been automatically generated for this query. To edit or view the results of this query, click the "Return to Query" link.
Custom Query Help
Query Name: Programs for "parent or spouse service"
Query Datasource: Program Questions
 
SELECT [StateName], [SurveyYear], [ProgramName], [ProgramAwardType], [TotalDollarsDisbursed], [NumberOfRecipients] FROM VW_ProgramQuestions WHERE ([SurveyYear] in ( '2009' ) AND [AwardUsedForParentOrSpouseService] in ( ' CHECKED' ) ) ORDER BY [SurveyYear] asc, [StateName] asc, [ProgramName] asc, [ProgramAwardType] asc