: subquery multiple rows
yea.. almost. but it helped a lot. now i know about those functions
too. thank you...
Nathan Sullivan wrote:
I think you want to do something like this:
select prod, group_concat(category separator ', ')
from products
group by prod;
Hope
On Wed, 2010-04-07 at 11:37 -0400, 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|
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:
yea.. almost. but it helped a lot. now i know about those functions
too. thank you...
Nathan Sullivan wrote:
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