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.

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