Given a data set: 'ndb_no','description' '02001','SPICE OR HERB (US CFR)' '02001','ALLSPICE' '02001','FINELY GROUND' '02001','NOT HEAT-TREATED' '02001','COOKING METHOD NOT APPLICABLE' '02001','WATER REMOVED' '02001','NATURALLY DRIED' '02001','SUN DRIED'
I'm seeking the capability to be able execute a query like: SELECT primary_key, CONCAT(description, ', ') from mytable group by primary_key (regardless of what the function name is, concat, array_aggregate, etc..) to yield results like: '02001','SPICE OR HERB (US CFR), ALLSPICE, FINELY GROUND, NOT HEAT-TREATED, COOKING METHOD NOT APPLICABLE, WATER REMOVED, NATURALLY DRIED, SUN DRIED' Does any functionality like this exist? If not, do we have any JIRA tickets that are asking for this? Thanks, Jim
