Please help me in grouping say for example I have 10 products in one table & it has almost 92 parts in the other table & 92 lines of details in 3rd table.
without passing parameters from outside stored procedure for product id, I want each product to have its related part beneath it & then the corresponding line items.
finally, these results will show in Json blocks.
please help