Hi,
This could a fairly generic database to XML problem.
I have 2 tables in mysql database with following columns
1. ID, field1,field2,field3
2. ID,type,value
In table 1, ID is the key and in table 2, ID can appear multiple times. Sample data for table 2: 
1,X,abc
1,X,pqrs
1,Y,mno
2,Z,pqr
2,X,abcd
2,X,apry
I like to to produce an XML strcture which correctly represents records with ID only once and with all the other related data. How I would go about it?

For single table, this could be very easy exercise. DBIx::XML_RDB as in How do I dump a database table into XML format?. I like to find solution for related tables.

Thanks
artist

In reply to XML Conversion of Tables by artist

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.