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 with Lottery as funding source
Query Datasource: Program Questions
SELECT [StateName], [ProgramName], [TotalDollarsDisbursed], [NumberOfRecipients], [LotteryDollarsExpended] FROM VW_ProgramQuestions WHERE ([SurveyYear] in ( '2009' ) AND [ProgramFundedByLottery] in ( ' CHECKED' ) ) ORDER BY [StateName] asc, [ProgramName] asc, [TotalDollarsDisbursed] asc, [NumberOfRecipients] asc, [LotteryDollarsExpended] asc