title: Crystal Reports: left outer join and filtering
body: <p>In Crystal Reports I'd like to join two tables on EmployeeId in a way that in the final result dataset I get EmployeeId where Type equals A or Type is null. I'd be easy to do it through command but I need to do it through table choice not command. When I left outer join the tables and filter records on condition Type=A or IsNull(Type) records with type value null are eliminated. Could you please advise how to do it?</p>
  
  <p><strong>Table 1</strong></p>
  
  <pre><code>EmployeeId
  1
  2
  3
  </code></pre>
  
  <p><strong>Table 2</strong></p>
  
  <pre><code>EmployeeId, Type
  1, A
  2, B
  3, NULL
  </code></pre>
  
  <p><strong>Result set</strong></p>
  
  <pre><code>EmployeeId, Type
  1, A
  3, NULL
  </code></pre>
  
  <p>Regards,
  Przemek</p>