Join two lists

Chetan koralli

Hi All,

I have two lists called

DocList
CommentsList

and in DocList i have a primaryKey column called Id
and which is a lookup column in CommentsList

now i want to join these two tables on this ID column to
retrive the unique documents count from CommentsLIst

can any one write camel query for this and let me know.

sql query look like follows

select distinct(count) from CommentsList CL innerJoin DocList DS on CL.ID = DS.ID

Or just provoide me solution how to retrive didtinct records from CommentsList

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Chetan koralli14y ago
Hi Hemanth,

I wanted a Camel query for this not the sql query.
Venkatesh Kumar14y ago
Please check the below link : http://blogs.msdn.com/b/kaevans/archive/2012/01/20/sharepoint-2010-caml-list-joins.aspx
Venkatesh Kumar14y ago
Please check the below link : http://blogs.msdn.com/b/kaevans/archive/2012/01/20/sharepoint-2010-caml-list-joins.aspx
Hemant Srivastava14y ago

If you just interested to get count, then query would be like:

SELECT COUNT(*) FROM CommentsList AS CL
INNER JOIN DocList AS DS ON DS on CL.ID = DS.ID

If you want to grab the records from their inner join:

SELECT DISTINCT * FROM CommentsList AS CL
INNER JOIN DocList AS DS ON DS on CL.ID = DS.ID