MySQL Lists are EOL. Please join:

List:General Discussion« Previous MessageNext Message »
From:kalin m Date:April 7 2010 4:59pm
Subject:Re: subquery multiple rows
View as plain text  


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 -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=1
>>
>>     
Thread
subquery multiple rowskalin m7 Apr
  • Re: subquery multiple rowsnwood7 Apr
  • Re: subquery multiple rowsNathan Sullivan7 Apr
    • Re: subquery multiple rowskalin m7 Apr
      • RE: subquery multiple rowsSteven Staples12 Apr