Join 3 lists initiating the join from the middle list

Question

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 web.get_lists().getByTitle("B"); via JavaScript.

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>

Answer 1

Pretty much, although you would want to left outer join your tables.

Have a look at this MSDN article for reference.