<Cases>
<Case tag="IT653294" requesting="IT" >
<Races>
<Race scheduled="2018-06-01" id="100"/>
</Races>
</Case>
<Case tag="IT831787" requesting="AB">
<Races>
<Race scheduled="2018-06-02" id="101" />
<Race scheduled="2018-06-02" id="102" />
</Races>
</Case>
<Cases>
SELECT
FROM xml xx
,XMLTABLE (XMLNAMESPACES (DEFAULT 'some_url') ,
'for $i in Cases/Case/Races/Race return $i'
PASSING xx.XMLDOC
COLUMNS scheduled Date PATH '@scheduled'
id NUMBER PATH '@id' ) x
this gives :
2018-06-01 100
2018-06-02 101
2018-06-02 102
I need the value of a parent node attribute
What I actually need is :
2018-06-01 100 IT653294
2018-06-02 101 IT831787
2018-06-02 102 IT831787
How can I get the parent value? Every help would be very appreciated.
Thanks in advance