If you query for multiple results, only the first Recordset is returned. If multiple result sets are needed, assign each to its own RDS.DataControl. An example of a query for multiple results could be "Select * from Authors, Select * from Topics".
"Select * from Authors, Select * from Topics"