I have three tables: Book, author and Book_Author. The third table make them one to many relation.One book may have more than one authors. Book table has Title column and Author table has AuthorName Column.
Book: BookID, Title
Author: ID, AuthorName
Book_Author: ID, BOOKID, AuthorID
I wrote a stored procedure to combine the titles with it's authors and When I
use just this:
SELECT BookID, Title from Book
Order by Title
it works fine but I have to call this procedure from c# with the input author and I changed this query to:
select B.BookID, B.Title, a.authorName from Book b join book_author ba on
b.bookID = ba.bookID join author a on
ba.authorID = a.ID
then it displays the duplicate records into title column for different authors.
Can I just display single title but multiple authors ??
Any help is highly appreciated.