From: castorrr-removeME-@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   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)