SELECT * FROM XMLParser ( ON xml_input2 Text_Column ('xml') Nodes ('Class:{A,B}/Year/Student', 'Year/Grade') Ancestor ('School/Dept') Accumulate ('xid') );
SELECT * FROM XMLParser ( ON xml_input2 Text_Column ('xml') Nodes ('Class:{A,B}/Year/Student', 'Year/Grade') Ancestor ('School/Dept') Accumulate ('xid') );