title: Left Outer Join SOQL
body: <p>I have the following entities:</p>
  
  <pre><code>&lt;complexType name="Account"&gt; 
   ..
   &lt;element name="Account__r" nillable="true" minOccurs="0" type="tns:QueryResult" /&gt; 
  ...
  ...
  &lt;complexType name="Address__c"&gt;
  ..
    &lt;element name="Account__c" nillable="true" minOccurs="0" type="tns:ID" /&gt; 
    &lt;element name="Account__r" nillable="true" minOccurs="0" type="ens:Account" /&gt;
  </code></pre>
  
  <p>I need to retrieve all the address of Account, given Address__c I can retrieve the accounts (SELECT Name,Account__r.Name, Account__r.AccountNumber FROM Address__c), but I need to pull all the addresses__c for each account.<br/></p>
  
  <p>So if one Account has not associated to any Address__c entries I want to show it in the results regardless.  </p>
  
  <p>How can I do that?</p>