asterix-app/src/test/resources/metadata/queries/custord_q4.aql

use dataverse custord;

write output to nc1:"rttest/custord_q4.adm";

for $c in dataset('Customers')
for $o in dataset('Orders')
where $c.cid = $o.cid 
order by $c.cid
return {"cust_name":$c.name, "cust_age": $c.age, "order_total":$o.total}