SELECT * FROM XMLParser ( ON xml_input1 Text_Column ('xmldocument') Nodes ('temperature/read:type', 'storage/{used, total}') Sibling ('settopid:{type, length}', 'accountid') Ancestor ('setTopRpt') OutputColumn_NodeID ('nid') MaxItemNum (1) Accumulate ('xid') ) ORDER BY 1,2;