in the last few years the tips in this forum always soved all of my problems without any need to post anything of my own.
now - i'm in trouble. i hope you can help.
my question is best asked using the picture attached.
i need to create a new table (right) from the table on the left.
i can phrase this questions SQLly...
SELECT COLA, COLB
GROUP BY COLA, COLB;