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.

4 Answers 4


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: http://msdn.microsoft.com/en-us/library/microsoft.sharepoint.spquery.joins(office.14).aspx


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.


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



You should use CAML Query Builder.

Please check: http://ranaictiu-technicalblog.blogspot.com/2011/01/u2u-caml-query-builder-for-sharepoint.html

  • 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, 2012 at 10:09

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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