LISTING 3: Template Containing Queries

<bibliography>
  <sql:query  xmlns:sql="urn:schemas-microsoft-com:xml-sql">
    SELECT 1        as Tag,
           NULL     as Parent,
           'S' + au_id    as [author!1!au_id!id],
           au_fname as [author!1!au_fname],
           au_lname as [author!1!au_lname],
           NULL     as [author!1!wrote!idrefs]
    FROM Authors
    UNION ALL
    SELECT 1        as Tag,
           NULL     as Parent,
           'S' + Authors.au_id,
           au_fname,
           au_lname,
           TitleAuthor.title_id
    FROM Authors, TitleAuthor
    WHERE Authors.au_id = TitleAuthor.au_id
    ORDER BY [author!1!au_id!id],[author!1!au_lname],[author!1!au_fname],[author!1!wrote!idrefs]
    FOR XML Explicit, XMLData


    SELECT 1        as Tag,
           NULL     as Parent,
           title_id as [book!1!title_id!id],
           title    as [book!1!title]
    FROM Titles
    ORDER BY [book!1!title]
    FOR XML Explicit, XMLData
  </sql:query>
</bibliography>