How can I join SharePoint Lists and read values?
LIST INNER JOIN
Drag a search grid into a form and edit the datasource from the designer part.
Step 1 : Please select two lists from the Available lists.
Step 2 : Select Columns from the both lists.
Step 3: Add a search criteria.
Step 4: Select parent table name, child table name and their corresponding columns by which the inner
join has to be done.
Step 5: Add columns which is to be shown in search grid.