<?xml version='1.0'?>
<root xmlns:sql='urn:schemas-microsoft-com:xml-sql' sql:xsl='get.xsl'>
<sql:query>
select prod_num,supp_code,unit_price from products for xml auto
</sql:query>
</root>
<?xml version='1.0'?>
<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/xsl/transform" version="1.0">
<xsl:template match='*'>
<xsl:apply-template />
</xsl:template>
<xsl:template match='products'>
<TR>
<TD align='center'><xsl:value-of select='@prod_num' /></TD>
<TD align='center'><xsl:value-of select='@supp_code' /></TD>
<TD align='center'><xsl:value-of select='@unit_price' /></TD>
</TR>
</xsl:template>
<xsl:template match='/'>
<HTML>
<BODY>
<TABLE border='1'>
<TR>
<TH>Product No.</TH>
<TH>Supplier Code</TH>
<TH>Unit price</TH>
</TR>
<xsl:apply-templates select='root' />
</TABLE>
</BODY>
</HTML>
</xsl:template>
</xsl:stylesheet>