CAML JOINS using SharePoint

Question

Assume that there are Emp and Dept tables.

Emp Table has

EmpID
FirstName
LastName
DeptName
Email

Dept table has

DeptID
DeptName

i have to display all the employee details based on DeptName using CAML query. Can some one share CAML JOINS example for this scenario.

Thank you

Have you tried to build the query using the U2U CAML Query Builder (http://www.u2u.net/res/Tools/CamlQueryBuilder.aspx)? This solves a lot of CAML-related headaches. — Kyle Trauberman, Aug 08 '11 at 18:11

score 2 · Answer 1 · answered Oct 29 '12 at 17:16

Check this approach very easy to join as many list as you want: Link

cawl_QueryBuilder cawl = new cawl_QueryBuilder();
cawl.Select("Users_Title");
cawl.Select("Users_Age");
cawl.Select("Users_Sex");
cawl.Select("CarBrand");
cawl.Join("UsersList";"OwnerColumn");
cawl.Get('UserCarsList');

StringBuilder Result = new StringBuilder();
foreach (SPListItem item in cawl.ListItemCollection())
{
  Result.Append(item["Users_Title"].ToString() +
                 item["Users_Age"].ToString() +
                 item["Users_Sex"].ToString() +
                 item["CarBrand"].ToString());

}
Label1.Text = Result .ToString();

score -1 · Answer 2 · answered Aug 08 '11 at 23:58

1) Are you on SP 2007 or SP 2010 2)On easy approach is create a querystring in SP designer and then show the employee details based on the query string from the URL If doesn't solve your proble then yiu have to take Kyle advice and do it from code and LINQ could be a good way to go

CAML JOINS using SharePoint

2 Answers2