r k

r k

  • 2k
  • 88
  • 3.4k

Grouping of fields

Sep 17 2021 6:16 PM

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 

Answers (4)