<?xml version="1.0" encoding="windows-1252"?>
<node id="997428" title="Re^5: SQL Database Table to Perl Script" created="2012-10-05 06:05:14" updated="2012-10-05 06:05:14">
<type id="11">
note</type>
<author id="324763">
marto</author>
<data>
<field name="doctext">
&lt;p&gt;This is a basic SQL question, not a Perl question. I suggest you take the time to learn basic SQL, and for that matter Perl and HTML (note you have &lt;c&gt;&lt;br&gt;&lt;/c&gt; tags after &lt;c&gt;&lt;td&gt;&lt;/c&gt; tags). You've been given advice already which mentions what SQL functions to read up on, I won't repeat that. I suspect you've been given this task as a learning exercise (be it in an educational establishment, or on the job training/learning), and would suggest you treat it as such.&lt;/p&gt;</field>
<field name="root_node">
997371</field>
<field name="parent_node">
997423</field>
</data>
</node>
