Everyone, Is this a bug or something....i am using the latest version of MySQL server and it works fine and convincing...but I observe that if I use the MAX() function....i got this
I include max() function to my select query.... Ex.. select max(A),B,C from table_name group by A; the result is not convincing....coz column B and C are not partner of A....if I manually select A,B,C from table_name; the result is not same with the other.... Assuming A is integer and B,C are string partners.... Anybody got this situation before...I badly need your opinion about this....i solve the problem by using a re-query method and its programmatically done...so I need a more precise and exact way to get this... or any explanation why the server response my query this way? R.B.Roa PhilCom Corporation Tel. No. 858-xxxx Mobile No. (63) (919-xxxxxxx) --------------------------------------------------------------------- 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
