I found the answer. What you want to do is something like this:

DECLARE @result varchar(max)

SET @result = ''

SELECT @result = @result + book_name + ', '

FROM book

WHERE author_id =...