Challenging SQL*Plus Reporting Question

From: <busch1_at_llnl.gov>
Date: 1997/02/13
Message-ID: <5du3dn$203_at_lll-winken.llnl.gov>#1/1

[Quoted] I have three tables:

Publication:                   Company:               Author:
pub_id_no varchar2(7)   pub_id_no varchar2(7)         pub_id_no varchar2(7)

[Quoted] pub_title varchar2(20) pub_company_name varchar2(20) pub_author_name varchar2(20) [Quoted] pub_date date

[Quoted] Each publication can have 0 through N companies Each publication can have 0 through N authors

I'd like a report like this:

Publication Title         Company                      Author

Title #1                  1st company of pub 1         1st author of pub 1
[Quoted]                           2nd company of pub 1         2nd author of pub 1
[Quoted]                           Nth company of pub 1         nth author of pub 1

[Quoted] Title #2 etc.

[Quoted] Is there any way to do this is SQL*Plus?

---
Jeff Busch             Internet busch1_at_llnl.gov
Voice (510) 423-9134   Fax (408) 263-1360

Received on Thu Feb 13 1997 - 00:00:00 CET