
I think you would probably have to hand code a loop through the first recordset results so you can get the corresponding rows and then add it to the array so you can json encode it if you wanted to do it on this page.

Yes I need to loop the second query result inside the JSON output of first query and in this place I become stuck. To get a view for a regular webpage it is easy for me that I bring the second query inside the 1st query repeat region and I can get the result what I want but to get a JSON output for the both query like nested I failed.
Can you pls guide me a bit here so that I can try.