Join two lists

Question

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