select query for one-to-many relations table?
I have 2 tables. These two tables have one-to-many relations. TABLE – A column1 column2 1 label1 2 label2 TABLE – B Bcolumn1 Bcolumn2 Bcolumn3 1 value1 value4 1 value2 value5 2 value3 value6 RESULT TABLE column1 column2 json 1 label1 [[value1,value4],[value2,value5]] 2 label2 [[value3,value6]] I want to get RESULT TABLE1 using TABLE – A… Read More select query for one-to-many relations table?