SELECT * FROM XMLParser ( ON xml_input1 Text_Column ('xmldocument') Nodes ('price/member') Sibling ('author', 'year', 'title') Sibling_Delimiter (';') Accumulate ('xid') ) ORDER BY 1,2;
SELECT * FROM XMLParser ( ON xml_input1 Text_Column ('xmldocument') Nodes ('price/member') Sibling ('author', 'year', 'title') Sibling_Delimiter (';') Accumulate ('xid') ) ORDER BY 1,2;