Error in CAML Query with multiple "AND"

Question

When I run the following query I get an error:

<Where>
   <And>
      <Eq>
         <FieldRef Name="IssueLOB" LookupId="TRUE" />
         <Value Type="Lookup">1</Value>
      </Eq>
      <Eq>
         <FieldRef Name="IssueBucket" LookupId="TRUE" />
         <Value Type="Lookup">1</Value>
      </Eq>
      <Eq>
         <FieldRef Name="IssueStatus" LookupId="TRUE" />
         <Value Type="Lookup">1</Value>
      </Eq>
  </And>
</Where>

However, when I run the following query(minus one of the Eq statements) everything works fine:

<Where>
   <And>
      <Eq>
         <FieldRef Name="IssueLOB" LookupId="TRUE" />
         <Value Type="Lookup">1</Value>
      </Eq>
      <Eq>
         <FieldRef Name="IssueBucket" LookupId="TRUE" />
         <Value Type="Lookup">1</Value>
      </Eq>
   </And>
</Where>

Can anyone point me in the right direction? Thanks very much in advance.

Answer 1

<Where>
<And>
<Eq><FieldRef Name="IssueLOB" LookupId="TRUE" /><Value Type="Lookup">1</Value></Eq>
<And>
<Eq><FieldRef Name="IssueBucket" LookupId="TRUE" /><Value Type="Lookup">1</Value></Eq>
<Eq><FieldRef Name="IssueStatus" LookupId="TRUE" /><Value Type="Lookup">1</Value></Eq>
</And>
</And>
</Where>

This should work!

You should use some CAML Query Builder like U2U Caml Query Builder, there are many other available!

Answer 2

FYI: In CAML each And (or ) conditional agregates can contain only a max of two filters. In order to have more than two you have to concatenate them as @arsalan-adam-khatri demonstrated.