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


1 answer



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.