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>