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
|
|
|
|