In a xml of the form:

Code:
<order>
    <header>
        <number>1</number>
    </header>
    <lines>
        <line>
            <id>1</id>
        </line>
        <line>
            <id>2</id>
        </line>
        <line>
            <id>3</id>
        </line>
    </lines>
</order
I want an output of the form header_nr | line_nr . That header number will allow me to join with the headers table to get the id, or else I won't know how to get a reference.

Any way to do this? Or can I get another approach? Thanks