0
votes
1answer
54 views

Join three Lists in CAML

Suppose that we have three tables(Three Lists in SharePoint).The relations between tables are described by the following image. I want to translate the following query to CAML query: select c.* ...
0
votes
2answers
942 views

Left Outer Join in SharePoint 2010

I have 2 lists in SharePoint 2010. First List E lists all locations. In the second list H I use first E list as lookup for Location. Every month users inputs information in list H. List E has ...
0
votes
2answers
353 views

CSOM list query with JOIN, return tree structure

I have two lists, Parent and Child. The Child list has a lookup field called "Parent", which "looks into" the Parent list, using ID column. Using CSOM I'm joining the lists with this query ...