I think you want to do something like this: select prod, group_concat(category separator ', ') from products group by prod;
Hope this helps. On Wed, Apr 07, 2010 at 08:37:04AM -0700, kalin m wrote: > > hi all... > > i have a bit of a problem with this: > > table products: > > ---------------------- > prod | category | > ---------------------| > boots | winter | > boots | summer | > boots | spring | > shoes | spring | > shoes | winter | > shoes | fall | > shoes | summer | > ---------------------- > > when i do this: > > select distinct prod as m, (select category from products where email > = m) as n from products; > > i get: > > ERROR 1242 (21000): Subquery returns more than 1 row > > i know that the subquery returns more than one rows. i hope so... > > what i'd like to see as result is: > > ------------------------------------------------- > m | n | > ------------------------------------------------- > boots | winter, summer, spring | > shoes | spring, winter, fall , summer | > ------------------------------------------------- > > > or at least: > > --------------- > m | n | > --------------- > boots | 3 | > shoes | 4 | > ---------------- > > > > > thanks.... > > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/mysql?unsub=nsulli...@cappex.com > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org