LISTING 1: FOR XML AUTO Query with a JOIN

SELECT TOP 5
  Author.au_fname AS FirstName,
  Author.au_lname AS LastName,
  Title.title     AS Name,
  Title.price     AS Price
FROM Authors Author, Titles Title, titleauthor
WHERE Author.au_id = titleauthor.au_id AND
  titleauthor.title_id = Title.title_id
ORDER BY Author.au_lname
FOR XML AUTO