I have a table with a column containing a duplicate values in order_no, and I would like to combine associated values in tracking_no into perhaps a new table, where there will be only ONE row with the order_no, but with tracking_no values comma separated.
Existing Table Data:
Desired Table Data:
I'm struggling with the logic ...
I can find the duplicates using for example:
SELECT order_no, Count(*) FROM shipping_data group by order_no HAVING ( COUNT(order_no) > 1 )
But don't know how to use those results properly..
I am assuming I should have another table to hold the "modified" results?
Many thanks for any help /pointers in the right direction!