My understanding is that you have comma separated ID values in one column and you want to get the associated text from another table to display it on the page.
The second recordset takes the ID's from the first recordset and returns the associated rows from the second recordset. Now that you have that, you can loop through the second recordset and display the values you want on the page.
It looks like your recordset is set up correctly. Now add the column value from the second recordset to the page where you want it and add a repeat region to show all of the values.