multiple querys

How can I query 2 different tables and get the result in 2 different result sets using 1 connector


I want to know if it is possible to use only one connector in order to execute 2 or more different select querys and store the returned values in differents resultsets.

And also if it is possible how to do it