How can I remove the shortcut for the SELECT clause used in GROUP BY?

Question

I have a request:

SELECT
  ...
  (some expression) AS Country
FROM
  Sometable
  ...
GROUP BY Country;

It works (I want to GROUP BYapply to the result column, and MySQL also understands this).

But he gives a warning:

Warning: Column 'Country' in group statement is ambiguous

, GROUP BY. , , ( : Sometable.Country). , , , . - Select.Country, , , , - SELECT, , .

, , ( ), , ( ).

+3

Jerome 09 . '11 17:29

2

, , :

Group By (some expression)

I.e., By. . - /.

+1

Thomas 09 . '11 17:32

Johan · Accepted Answer · 2011-06-09T17:30:54+0000

SELECT a,b,c,d, country2 AS country FROM (
   SELECT
  a,b,c,d,
  (some expression) AS Country2
  FROM
    Sometable
    ...
  GROUP BY Country ) s;