Re: [PHP] [PHP-DEV] SQLite - Unwanted values using group-by

On Sun, Jul 8, 2012 at 12:07 AM, Simon Schick wrote: > Hi, All > > May you have an idea ... > > Here's the full code-example: > http://viper-7.com/M5mldG > > I have the following SQL command: > > SELECT max(r.month+r.year*100), r.year, r.month > FROM base b LEFT JOIN remote r ON b.id = r.remote_id

[PHP] [PHP-DEV] SQLite - Unwanted values using group-by

Hi, All May you have an idea ... Here's the full code-example: http://viper-7.com/M5mldG I have the following SQL command: SELECT max(r.month+r.year*100), r.year, r.month FROM base b LEFT JOIN remote r ON b.id = r.remote_id GROUP BY r.remote_id Now I expect that the first column in the results