#1140 - Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause

#1140 - Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clausehttp://softtime.ru/forum#1140 - Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clausehttp://softtime.ru/forum/read.php?id_forum=3&id_theme=71080#post417317Это ошибка неоднозначного группирующего запроса. В некоторых случаях MySQL такие запросы всё ж таки отвергает, как и положено уважающему себя...#1140 - Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clauseSat, 16 Jan 2010 18:27:03 +0300Trianon#1140 - Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clausehttp://softtime.ru/forum/read.php?id_forum=3&id_theme=71080#post417316не помогло...#1140 - Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clauseSat, 16 Jan 2010 18:01:18 +0300tjslash#1140 - Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clausehttp://softtime.ru/forum/read.php?id_forum=3&id_theme=71080#post417315GROUP BY нужен в первом селекте тоже#1140 - Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clauseSat, 16 Jan 2010 16:57:33 +0300ride#1140 - Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clausehttp://softtime.ru/forum/read.php?id_forum=3&id_theme=71080#post417312сделал 6 - 6, не помогает...#1140 - Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clauseSat, 16 Jan 2010 16:20:59 +0300tjslash#1140 - Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clausehttp://softtime.ru/forum/read.php?id_forum=3&id_theme=71080#post417308в первом 5 во втором 6, не верите посчитайте запятые (не может меня так сильно торкать хотя и провел всю...#1140 - Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clauseSat, 16 Jan 2010 16:05:35 +0300Valick#1140 - Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clausehttp://softtime.ru/forum/read.php?id_forum=3&id_theme=71080#post417305Почему? И там, и там по 5... Вроде...#1140 - Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clauseSat, 16 Jan 2010 15:56:26 +0300tjslash#1140 - Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clausehttp://softtime.ru/forum/read.php?id_forum=3&id_theme=71080#post417301помоему количество полей селектов не совпадает#1140 - Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clauseSat, 16 Jan 2010 15:40:40 +0300Valick#1140 - Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clausehttp://softtime.ru/forum/read.php?id_forum=3&id_theme=71080#post417300Ошибка: #1140 - Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY...#1140 - Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clauseSat, 16 Jan 2010 15:22:09 +0300tjslash