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