Hi I am working in MySQL 5. I came across a requirement. There is a table tbl having 2 columns id and value. Having entries like aaa 1 bbb 2 ccc 3 bbb 1 No i need the output for id 'bbb' as bbb 2,1 or bbb 1,2 Can anybody get me the query to get such result. Its like getting comma seperated values for a particular id. Thanks in advance Imran Rahi __________________________________ Yahoo! FareChase: Search multiple travel sites in one click. http://farechase.yahoo.com ------------------------ Yahoo! Groups Sponsor --------------------~--> Get Bzzzy! (real tools to help you find a job). Welcome to the Sweet Life. http://us.click.yahoo.com/A77XvD/vlQLAA/TtwFAA/saFolB/TM --------------------------------------------------------------------~-> PHP Data object relational mapping generator - http://www.meta-language.net/ Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/php-objects/ <*> To unsubscribe from this group, send an email to: php-objects-unsubscribe@xxxxxxxxxxxxxxx <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/