I have an object that has orders. Each order can have related orders, which can have related orders.....
I need to do a query to find all order-ids (and other details) about the top order and any related orders underneath.
I have this xml format
<orderstatus> //this is recursive
//I removed the duplicate lines