SELECT * FROM O_Sessions AS first, O_Sessions AS second WHERE first.iSession=MAX(second.iSession) AND first.iUser=second.iUser
yes, nice idea, but in mySQL, grouping functions like MAX are only allowed in SELECT ... FROM, not in the WERE part :-( But i will remember this way to work around the GROUP BY. What about speed ? System would only have to group 'second', in order to find the recordset, that has the greatest iSession... Thank's for your suggestion anyway, roland (poor little mysql user :-) ) ... My work around in mysql: i simply store data from the latest O_Sessions in additional fields of O_Users, thereby omitting any GROUP BY things :-) 3:22 not far from dawn, now heading directly for bed, roland two weeks from now, have a look at www.snoopme.com :-) --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
