declare @x xml
set @x = (
select [FirstName] + ' ' + [LastName] as Author, [NameBook]
from [Authors], [Books]
where [AuthorId] = [Authors].[Id]
order by [FirstName], [LastName], [NameBook]
for xml PATH, TYPE
)
select @x

<row>
  <Author>Aaron Lennon</Author>
  <NameBook>aaaaa</NameBook>
</row>
<row>
  <Author>John Muscett</Author>
  <NameBook>ddddd</NameBook>
</row>
<row>
  <Author>John Muscett</Author>
  <NameBook>fdsfsd</NameBook>
</row>
<row>
  <Author>Patric Evra</Author>
  <NameBook>zzzzzzz</NameBook>
</row>
<row>
  <Author>Patric Lnjumberg</Author>
  <NameBook>vvvvvvv</NameBook>
</row>

<row>
  <Author>Aaron Lennon</Author>
  <NameBook>aaaaa</NameBook>
</row>
<row>
  <Author>John Muscett</Author>
  <NameBook>ddddd</NameBook>
  <NameBook>fdsfsd</NameBook>
</row>
<row>
  <Author>Patric Evra</Author>
  <NameBook>zzzzzzz</NameBook>
</row>
<row>
  <Author>Patric Lnjumberg</Author>
  <NameBook>vvvvvvv</NameBook>
</row>