LISTING 2: FOR XML AUTO Query with a SELF-JOIN

SELECT TOP 5
  Author.au_lname AS FirstName,
  Author.au_fname AS LastName,
  Address.address AS Street,
  Address.city    AS City,
  Address.state   AS State,
  Address.zip     AS Zip
FROM Authors Author, Authors Address
WHERE Author.au_id = Address.au_id
ORDER BY FirstName
FOR XML AUTO