Select Code to Download

A1 abc blue:green:yellow
A2 cde red:yellow
B1 xyz green

# Ok,  with SELECT DISTINCT * and using Perl for Printout

...
{
   print "$key ",join (':',sort @{$result{$key}}),"\n";
}

#!usr/bin/perl
use warnings;
...
A1 abc green
A2 cde yellow
A1 abc blue