How list matching fields and Update in MySQL

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.


Source: mysql

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.