Re: Query Question
From: Shakespeare <whatsin_at_xs4all.nl>
Date: Thu, 19 Jun 2008 20:10:02 +0200
Message-ID: <485aa0fb$0$14353$e4fe514c@news.xs4all.nl>
Date: Thu, 19 Jun 2008 20:10:02 +0200
Message-ID: <485aa0fb$0$14353$e4fe514c@news.xs4all.nl>
"Mtek" <mtek_at_mtekusa.com> schreef in bericht
news:c80264dd-be17-4754-a00e-483b4182e855_at_l28g2000prd.googlegroups.com...
>
> Hi,
>
> Is it possible to return all rows from a query on one line?
>
> I have this query:
>
> SELECT cnt || ':' || t_id
> FROM (SELECT COUNT(*) cnt, t_id
> FROM zc_body zb, zc_type zt
> WHERE zb.t_id = zt.id
> group by t_id);
>
> It returns data like this:
>
> 86:3
> 994:7
> 99:18
> 38:27
> 45:36
>
> However, they want it in one line: 86:3,994:7,99:18,38:27,45:36
>
> Can this be done?
>
> Thanks!
>
> John
>
Give 'them' a text editor.
Shakespeare Received on Thu Jun 19 2008 - 13:10:02 CDT