Hi, I have a table as shown with approx 500 lines:
--------------------------------------------------- Tndr | Detail | ---------------------------------------------------- 34 | one | 47 | two | 34 | three | 55 | four | 47 | five | There can be multiple 'tndr' fields with same values. I need to do something so that i can get the output as following: 34 > one - three 47 > two - five 55 > four Is there a direct query to do that OR any ideas on what lines shall i think to modify my database(if needed). Thanks and Regards Anil --------------------------------------------------------------------- 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