Hi everybody --
Sorry this is such a basic question, but how can I GROUP BY the product of a CONCAT(), as in:
SELECT CONCAT(colnum1,colnum2)
FROM table
GROUP BY [the concatted thing]
I tried to name the product, but that didn't help. Does anyone have a clue? Thanks!