Query Question

From: Mtek <mtek_at_mtekusa.com>
Date: Thu, 19 Jun 2008 10:42:49 -0700 (PDT)
Message-ID: <c80264dd-be17-4754-a00e-483b4182e855@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 Received on Thu Jun 19 2008 - 12:42:49 CDT

Original text of this message