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;
RId as RatingJoin,
PIncIPT - PExIPT,
From_Field('Policy','RD') (xmlSimple, table is [RatingData]);
I as [True/False],
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.....