title: How to do double orderby in CAML Query?
body: <p>I am using camel query in visual studio c# to get items from a list from sharepoint 2010. The list items has two fields that I want to use in the caml query. One is "Section" and the other is "Order By". The query needs to order the items in a certain way. First it needs to sort it by Section (ascending=true), and then for each a secondary sorting by Order By (ascending = true).</p>
  
  <p>For example the result would be like this:</p>
  
  <pre><code>&lt;item&gt; &lt;Section&gt; &lt;Order By&gt;
  item1  A 1
  item2  A 3
  item3  B 1
  item4  B 2
  item5  C 5
  item6  C 6
  </code></pre>
  
  <p>So far I have this:</p>
  
  <pre><code>        SPQuery query = new SPQuery();
          query.Query = "&lt;Query&gt;&lt;OrderBy&gt;&lt;FieldRef Name='" + Root_List.Fields.GetField(SECTION_COLUMN).InternalName + "' Ascending='True'/&gt;&lt;/OrderBy&gt;&lt;/Query&gt;";
          item_collection = Root_List.GetItems(query);
  </code></pre>
  
  <p>But how do I apply the secondary orderby?</p>
  
  <p>Note: Section is a string field and order by is a number field.</p>