SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

When using SP 2007 and needed to do a join i just write the tables to a sql table and then use sql to join the tables. What i really need to do is quite simple. I have a master list and another list that users insert records too lets say a child list. When a user opens up the master list and clicks on an item i insert a record including their usernames to the child list All i want to show the users(based on login names) is the items they haven't read and what items. In sql i could have done something like e.g

 Select * from master where not in(select from child where username ='blalal')

Any ideas.Not sure if to do it on the client or in the object model. Sure CAMl doesn't have joins

Thanks in advance

share|improve this question
up vote 1 down vote accepted

SharePoint 2010 is supporting CAML joins. You can look for this example and msdn article: List Joins and Projections

share|improve this answer
IAfanasov thanks for that great sample. Can i always adda where clause to that? – naijacoder Jan 30 '12 at 3:26

Your Answer


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.