Captain Paralytic wrote:
> On 25 Oct, 14:12, panchettone <pan_che_ttone@non_morde.bau> wrote:
>> Captain Paralytic ha scritto:
>>
>>
>>
>>> Well that's basic GROUP BY syntax!
>> well, the fact is I don't need any group by
>
> OH, well you had better argue that out with MySQL because it says you
> do!
>
> If you are not happy with the syntax supplied by the MySQL product and
> SQL, you had better write your own RDBMS and your own SQL standard!
>
>

It's more than just MySQL, Paul. That's part of the SQL standard. In
fact, MySQL has historically been much more lenient than other databases.

IIRC, the SQL standard requires that when you mix aggregate functions
with columns (or non-aggregate functions) you must GROUP BY all
non-aggregate columns or functions. MySQL hasn't enforced it that much
in the past.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================