Collection
From: The Magnet <art_at_unsu.com>
Date: Thu, 24 Jun 2010 08:07:05 -0700 (PDT)
Message-ID: <79ed2576-8b7e-460c-b848-e957156ccc2b_at_u7g2000yqm.googlegroups.com>
M_TICKER
Date: Thu, 24 Jun 2010 08:07:05 -0700 (PDT)
Message-ID: <79ed2576-8b7e-460c-b848-e957156ccc2b_at_u7g2000yqm.googlegroups.com>
Hi,
This query basically does that I want:
SELECT body_id, COLLECT(m_ticker) AS m_ticker
FROM zc_body zb, zc_ticker_body zt
WHERE zb.body_id = zt.id
AND body_id = 39
GROUP BY body_id;
BODY_ID
M_TICKER
39
SYSTPicg9tK7GadHgQAB/AQBGww==('LNUX', 'MSFT', 'RHAT')
However, I really do not need that strange ID. Any way to chop it off? Received on Thu Jun 24 2010 - 10:07:05 CDT