Help needed with report / query

Hi,

I have a report that I'm trying to create that uses a query joining three tables. The primary table has a many-to-one relationship to the other two tables. My intent is to return only one row from the primary table and the multiple rows from the associated tables.

If I use only one of the many-to-one tables, I can use grouping to produce the desired results. But adding the second many-to-one related table produces one report line for each entry in the second table.

The second many-to-one table returns multiple text rows for my report. The end point that I would like to reach with this second table in the report is to have these multiple rows of text presented as a single body of text. Is there a way to concatenate the multiple text rows into one text row at query run time? Is there a function or procedure that could be created to accomplish this?

The basic query is: (a is the primary table)

select a.requestowner, b.componentid,c.description from request a, requestcomponent b, requestinfo c where b.requestid(+) = a.requestid
and c.requestid(+) = a.requestid
/

I am working in an NT 4.0 (service pack 6) environment using Oracle 8.0.6 as the database and Oracle reports 6i as the reporting package.

I'm a relative novice and this one has me stumped. Any help would be appreciated.

Ed Ziegler Received on Thu Oct 12 2000 - 11:51:23 CDT