xquery version "1.0";
declare copy-namespaces no-preserve, inherit;
declare variable $custid as xs:integer external;
declare variable $ordid as xs:integer external;


for $customerorder in //CUSTOMERORDERS/CUSTOMERORDER, $customer in $customerorder/CUSTOMER, $order in $customerorder/CUSTORDER, $orderitem in $order/ORDERITEM
	where $customer/CUSTOMERID = $custid and $order/ORDERID = $ordid
	order by 
		string-length($customer/CUSTOMERID) , string-length($order/ORDERID)
	return
		<customerorder>
			<customer>
				{ $customer/CUSTOMERID } 
				{ $customer/CUSTOMERFIRSTNAME } 
				{ $customer/CUSTOMERLASTNAME } 
				{ $customer/CUSTOMEREMAIL } 
			</customer>
			
			<order>
				{ $order/ORDERID } 
				{ $order/ORDERDATE } 
				<orderitem>
					{ $orderitem/ITEMID }
					{ $orderitem/NUMBER }
					{ $orderitem/INSTRUCTIONS }
				</orderitem>
			</order>
		</customerorder>