RE: ??? Simple sql-question: SELECT iSession FROM O_Sessions GROUP BY iUser

Well if you want the latest and greatest iSession irrespective of the user use select max(iSession) from O_Sessions; If it is to be grouped by user, then select user, max(iSession) from O_Sessions group by user; This will give you the max iSession for a user. Regards Satish -Original Mes

Heiki, Is this problem fixed in 4.02.

Hi Heikki, I am addressing this mail specifically to you, because I am still trying to create a small reproducable test case. The brief description is that on Windows MySQL 4.01 a left join query of two tables gives different results at different times even when executed on a mysql command line.