tags:

views:

27

answers:

0

Is there an easy way to produce efficient xml from ms access from an outer join?

ie, instead of repeated rows i'd like multiple subkeys

so from joining a customer table with an order table,

<customer>
 <custId>1</custId>
 <order>
  <orderId>1</orderId>
  <orderId>2</orderId>
 </order>
</customer>

instead of

<customer>
 <custId>1</custId>
 <order>
  <orderId>1</orderId>
 </order>
</customer>
<customer>
 <custId>1</custId>
 <order>
  <orderId>2</orderId>
 </order>
</customer>