[NEWBIE] Help with a simple query

i have two tables

BOOK

CODE         NOT NULL  NUMBER
TITLE                  VARCHAR2(45)
YEAR                   NUMBER

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

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 Thu Jul 29 2004 - 03:28:06 CEST