title: Salesforce SOQL To Get Case Owner In One Hit
body: <p>Using Salesforce SOQL I can get the Owner's Id using the following:</p>
  
  <pre><code>SELECT Case.OwnerId 
  FROM Case 
  WHERE Case.CaseNumber = '00001234'
  </code></pre>
  
  <p>I can then get the User details for the User who owns the case in this query:</p>
  
  <pre><code>SELECT User.Id, User.Name, User.Custom_Field__c 
  FROM User 
  WHERE User.Id = '001A0000001abc1DEF'
  </code></pre>
  
  <p>But I can't get it to work in a single statement, I think this is because Owner != User, even though the owner is in fact a user in this case. I have tried:</p>
  
  <pre><code>SELECT Owner.Custom_Field__c
  FROM Case 
  WHERE Case.CaseNumber = '00001234'
  </code></pre>
  
  <p>But I get an error that the Custom_Field__c is not a valid field.</p>