Re: sql query

From: Rene Nyffenegger <rene.nyffenegger_at_gmx.ch>
Date: Wed, 5 Oct 2005 21:43:40 +0000 (UTC)
Message-ID: <di1hec$og4$1@klatschtante.init7.net>

On 2005-09-30, Tom76 <brk15_at_hotmail.com> wrote:
> 1. the output from a table is as follows:
> col1
> ----
> a
> b
> c
> d
> e
> f
>
>
> 6 rows selected.
>========================================
> 2. but i want to display the sql output as:
> col1
> ----
> a,b,c,d,e,f
>
>
> 1 rows selected.
>===========================================
> how do i do that. thanks

http://www.adp-gmbh.ch/blog/2005/march/28.html might help.

Rene

-- 
  Rene Nyffenegger
  http://www.adp-gmbh.ch/

Received on Wed Oct 05 2005 - 16:43:40 CDT