View Single Post

   
  #2 (permalink)  
Old 02-28-2008, 07:52 AM
Paul Lautman
 
Posts: n/a
Default Re: Format query result.

Kasper K wrote:
> Hi ppl,
>
> Im having the time of my life with this database *sigh*
> Anyways, i have this problem which I can't solve. I would like to
> format the query result.
>
> I have a table like this:
>
> art_no
> 203
> 412
> 592
> 645
>
> Now i want to break the rule and have my output looking like this:
>
> 203 412 592 645
>
> So I get it on one row!
>
> Is this possible?
>
>
> Regards,
> Kasper K.


Take a look at the GROUP_CONCAT function


Reply With Quote