Sharepoint - How to write CAML Query with more than 3 AND Condition
Just continue to nest the queries...
<And>
<Eq>... condition...</Eq>
<And>
<Eq>... condition...</Eq>
<And>
<Eq>... condition...</Eq>
<And>
<Eq>... condition...</Eq>
<Eq>... condition...</Eq>
</And>
</And>
</And>
</And>
just use CAML Query builder. This is free tool, just use it's visual interface to create queries of different complexity.
Update: The link to u2u builder above is broken now. Currently I use SPCAMLQueryHelper from codeplex instead.