I am new to CAML query and as much as I have expected it to be simple like SQL I have found it quite frustrating to deal with. I have a simple query SQL query I am trying to translate into CAML but do not receive the expected result.
Select column1, column2, column3, column4, column5 from Table1 where column1 = 'Bob' and column2 = 'Marley';
My CAML query is:
<Query><Where><And><Eq><FieldRef Name=\'Column1\'/><Value Type=\'Choice\'>Bob</Value></Eq><Eq><FieldRef Name=\'Column2/><Value Type=\'Choice\'>Marley</Value></Eq></And><Eq><FieldRef Name=\'Column3\'/></Eq><Eq><FieldRef Name=\'Column4\'/></Eq><Eq><FieldRef Name=\'Column5\'/></Eq>
Any help is appreciated. Thanks.