I am getting records from a database and converting in to xml file. The record example is
<record><question>Question 1</question><answer>Answer 1</answer></record>
Question is getting from a table and answer is from another table.I have written the code for getting the questions and displaying but how can i do to fetch the answers for the question from another table. Also if i want to get a single record how to do it.

use warnings;
use strict;
use XML::Simple;
use DBI;

my $dbh = DBI->connect('DBI:mysql:sample','root')
  or die DBI->errstr;

# Get an array of hashes
my $recs = $dbh->selectall_arrayref('SELECT * FROM test',{ Columns => 
+{} });

# Convert to XML where each hash element becomes an XML element
my $xml = XMLout( {record => $recs}, NoAttr => 1 );

print $xml;

$dbh->disconnect;
[download]