[NEWBIE] Help with a simple query

From: castor. <castorrr-removeME-_at_fastwebnet.it>
Date: Thu, 29 Jul 2004 03:28:06 +0200
Message-ID: <GoYNc.102722$G%.42816@tornado.fastwebnet.it>

hi all,

i have two tables

BOOK

---

CODE         NOT NULL  NUMBER
TITLE                  VARCHAR2(45)
YEAR                   NUMBER

AUTHOR

---

A_NAME       NOT NULL   VARCHAR2(15)
DESCRIPTION             VARCHAR2(40)

i had an n->n relation with title/a_name, so i created a mid entity:

BOOK_AUTHOR

---

TITLE
A_NAME After that i created the following view

create view ALL as
(select Code, BOOK.Title, AUTHOR.A_Name
  from BOOK, BOOK_AUTHOR, AUTHOR
  where (BOOK.Title=BOOK_AUTHOR.Title AND

          BOOK_AUTHOR.A_Name=AUTHOR.A_Name);

So, where's my problem? When a book is written by multiple authors. when i select the view, multiple authors are put in multiple lines. Is there any way out?

thx for help, cas Received on Wed Jul 28 2004 - 20:28:06 CDT