Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

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
add comment

4 Answers

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

share|improve this answer
add comment

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
add comment

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

http://blogs.msdn.com/b/kaevans/archive/2012/01/20/sharepoint-2010-caml-list-joins.aspx

share|improve this answer
add comment

You should use CAML Query Builder.

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

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
add comment

Your Answer

 
discard

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.