How can I query 2 different tables and get the result in 2 different result sets using 1 connector
My answer is yes and no.
No because you can't do this if you use the default sql connector. They accept only 1 query and return 1 resulset.
Yes because you can create your own connector that will execute 2 or more query and return 2 or more resultset.
If you have two distincts queries, I recommand to create two task that will both execute one query. It is more readable.