Re: Help needed with report / query

Try

1. Going thru the documentation about driving table/driven table.
2. Having a correlated sub-query
3. Having in-line views.

Regards...
... Atul

Ed Ziegler wrote:
>
> 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
>

--
Posted via CNET Help.com
http://www.help.com/