SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Will you please provide me help to create a join between two SharePoint lists using CAML Queries. I am using SharePoint 2010 Development Platform. Thanks in advanced.

share|improve this question
up vote 2 down vote accepted

It's not possible to do a formal "Join" like you would using straight SQL, it just isn't supported by straight CAML.

You can use SPQuery.Joins:

share|improve this answer

An easy way to getting the Join CAML query syntax is using the Linq to SharePoint to generate the proxy of the required lists. Then writing the join statements using Linq in your C# code behind.

Run the code and set up a breakpoint at that specific statement where you are writing the join. In the quick watch window, you will be able to see the join syntx in CAML.

share|improve this answer

I found this article very much helpful to understand how can I create a join in caml and linq

share|improve this answer

You should use CAML Query Builder.

Please check:

share|improve this answer
We prefer inclusion of the essential parts of the answer here, and to provide the link for reference. See answer for general guidelines. – SPDoctor May 31 '12 at 10:09

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.