I need to join 3 Lists, but i have no access to the on-prem sharepoint to test my idea right now. So I hope anybody can tell me, if it's possible.
I have Lists A, B and C. LookupFields are connected from List C -> B -> A. (one LookupField each)
I want to start the join from List B. I get list B with
So starting the join from list B, would something like this be possible?
<Joins> <Join Type='INNER' ListAlias='A_'> <Eq> <FieldRef Name='LookupField_in_B' RefType='ID'/> <FieldRef List='A_' Name='ID'/> </Eq> </Join> <Join Type='INNER' ListAlias='C_'> <Eq> <FieldRef List='C' Name='LookupField_from_C_to_B' RefType='ID'/> <FieldRef List='C_' Name='ID'/> </Eq> </Join> </Joins>