Thanks for the quick reply Sean.
The above is an example only, there are 14 tables in total and the end-user will be dragging and dropping the xml file into a VB application.
I couldn't imagine sending 14 XML files and the user dropping 14 files onto the app on every update.
I could join the xml files during the export, but I'm very sure there must be a simpler solution from SQL.
I appreciate your input 🙂
Kind Regards,
Riaan