def DEP as SELECT * FROM department def EMP as SELECT e.name, e.age, e.salary FROM employee e WHERE e.depname = ? element COMPANY { exec DEP() for each DEP { element DEPARTMENT { output NAME DEP.name exec EMP(char DEP.name) for each EMP { element EMPLOYEE { output NAME EMP.name output AGE EMP.age output SALARY EMP.salary } } } } }