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: Loan Assumption and Cond Grant by State 2010
Query Datasource: Program Questions
SELECT [SurveyYear], [StateName], [ProgramName], [TotalDollarsDisbursed], [NumberOfRecipients] FROM VW_ProgramQuestions WHERE ([SurveyYear] in ( '2010' ) AND [ProgramAwardType] in ( 'Conditional grant or loan' , 'Loan assumption or forgiveness' ) ) ORDER BY [SurveyYear] asc, [StateName] asc, [ProgramName] asc