This is my XML content:
<ListEnginsMesures>
<EnginsESC>
<NomValide>Engin_inconnu</NomValide>
<NomEquivalents>
<NomEquivalent>Engin inconnu</NomEquivalent>
<NomEquivalent>Engininconnu</NomEquivalent>
</NomEquivalents>
</EnginsESC>
<EnginsESC>
<NomValide>DRSC_6150</NomValide>
<NomEquivalents>
<NomEquivalent>DRSC 6150</NomEquivalent>
<NomEquivalent>DRSC6150</NomEquivalent>
<NomEquivalent>DRSC6.150</NomEquivalent>
<NomEquivalent>DRSC_6.150</NomEquivalent>
</NomEquivalents>
</EnginsESC>
<ListEnginsMesures>
I want to select value of 'NomValide' when i have 'NomEquivalent'.
For example :
(select 'NomValide' where 'NomEquivalent' = "Engin inconnu") will return Engin_inconnu.
(select 'NomValide' where 'NomEquivalent' = "DRSC_6.150") will return DRSC_6150.
HOW CAN I ACHIEVE THIS ONE ?
THANKS IN ADVANCE..
No comments:
Post a Comment