I understand that a simple ".conv" converter with the SQL output or a SQL/XML query would retrieve the following:
<row>
<EQP_ID>01</EQP_ID>
<EQP_NAME>EQP01</EQP_NAME>
<CONN_ID>02</CONN_ID>
<CONN_NAME>PWR</CONN_NAME>
</row>
<row>
<EQP_ID>01</EQP_ID>
<EQP_NAME>EQP01</EQP_NAME>
<CONN_ID>03</CONN_ID>
<CONN_NAME>TX</CONN_NAME>
</row>
However, I would like the output to be something like this:
<row>
<equipment ID="01" NAME="EQP01">
<connector ID="02" NAME="PWR"/>
<connector ID="03" NAME="TX"/>
</equipment>
</row>
Is it possible? How can I do this?
Thanks,
Thiago.