Querying XML

[Anonymous]

Hi All,

Above is my XML which I have been able to query to a certain point. However, I am having trouble linking the "CP" element back to the RId.

How would you get the RId?

My XML Query looks like;

XMLOutput:

Load

RId as RatingJoin,

PIncIPT ,

PExIPT ,

PIncIPT - PExIPT,

From_Field('Policy','RD') (xmlSimple, table is [RatingData]);

CPOutput:

Load

[RatingData/RId],

I as [True/False],

V

From_Field ('Policy','RD') (xmlSimple, table is [RatingData/CP/CPI])

where I = 'true'

but for the life of me, I cannot join CPOutput to join back to the RatingData XMLQuery.....