I have a 3 tables

1. tBooks
---------

id
Title
authorID

2. tAuthors
-----------

id
Name

3. TBookAuthors
---------------

bookID
authorID

a book can have a few authors, an author can write a few books

So i need to search a book by name and select all the authors in the one record.

i tried like this, but result is a few records (how much authors). Only diference between this record is the name of author.

```
select a.[ID], a.[title], c.[name] 
from tBooks a
    inner join tBookAuthors b
    on a.[ID] = b.bookID
    inner join tAuthors c
    on b.[authorID] = c.[ID]
where title like '%Blen%'

```