title: Doing a join with SOQL
body: <p>Here is my SOQL problem.</p>
  
  <p>Query 1:</p>
  
  
  
  <pre class="lang-sql prettyprint-override"><code>Select 
    c.Date_Joined__c, 
    c.Email, 
    c.FirstName, 
    c.LastName, 
    c.regcode__c 
  from Contact c WHERE c.regcode__c ='XXXXXXXXX'
  </code></pre>
  
  <p>Query 2:</p>
  
  <pre class="lang-sql prettyprint-override"><code>Select 
    p.Account__c, 
    p.Date__c, 
    p.Points__c, 
    p.Description__c, 
    p.Code__c 
  from Points__c p where p.Account__c ='YYYYYYYYYYYY' and (p.Points__c &gt; 0) 
  Order by p.Date__c DESC
  </code></pre>
  
  <p>The relationship between the two queries is that <code>c.regcode__c</code> will have the same value as <code>p.Code__c</code>.</p>
  
  <p>I want to combine <strong>Query1</strong> and <strong>Query2</strong>, so <code>c.regcode__c = p.Code__c</code></p>
  
  <p>I'm stuck, I can't seem to get the syntax right for SOQL.
  Is it even possible to do joins in the API?</p>