Multiple Record Set
<p>I have to fill a DataSet with multiple RecordSet's. That is, I have a query which returns multiple tables, and I want to fill the dataset with that, but I can't figure out how.</p>

<p>The query I'm using is:</p>



<pre class="lang-sql prettyprint-override"><code>select emp_id, emp_fullname, dept_name, branch_name 
from view_emp_info 
where status_id = 1
order by branch_name, dept_name
compute count(emp_id) by branch_name, dept_name
</code></pre>

<p>Thank you in advance.</p>
