title: Sharepoint 2013 .NET CSOM CamlQuery Join
body: <p>I am unable to create a working query with join in my .net csom application. I was using this article:</p>
  
  <p><a href="http://msdn.microsoft.com/en-us/library/ff798388.aspx" rel="nofollow">http://msdn.microsoft.com/en-us/library/ff798388.aspx</a></p>
  
  <p>here is my code:</p>
  
  <pre><code> ClientContext context = new ClientContext(url);
   Web web = context.Web;
   var list = web.Lists.GetByTitle("Esemény");
  
   CamlQuery cq = new CamlQuery();
   cq.ViewXml= @"&lt;View&gt;
                     &lt;ViewFields&gt;
                         &lt;FieldRef Name='Title' /&gt;
                     &lt;/ViewFields&gt;
                     &lt;ProjectedFields&gt;
                         &lt;Field Name='PartnerLookupTitle' Type='Lookup' List='PartnerLookup' ShowField='Title' /&gt;
                     &lt;/ProjectedFields&gt;
                     &lt;Joins&gt;
                         &lt;Join Type='LEFT' ListAlias='PartnerLookup'&gt;
                             &lt;Eq&gt;
                                 &lt;FieldRef Name='Partner' RefType='ID' /&gt;
                                 &lt;FieldRef List='Partner' Name='ID' /&gt;
                             &lt;/Eq&gt;
                         &lt;/Join&gt;
                     &lt;/Joins&gt;
                 &lt;/View&gt;";
  
  ListItemCollection lista =  list.GetItems(cq);
  context.Load(lista);
  context.ExecuteQuery();
  </code></pre>
  
  <p>I get an exception from the server:
  "Value does not fall within the expected range."</p>
  
  <p>If I remove the the ProjectedFields and Joins part of the CAML query it works:(</p>