IMAGE EXAMPLE: http://imgur.com/XKmAMOm
I would like to aggregate SKU based on matching BASE SKU to generate the blue colmun. I would like to have the SQL code update this table to SET the GROUP column, not just show it temporarily.
I’ve ben trying everything from GROUP_CONCAT to loop but having no success. Can you please help? Thank You.