title: How to get get a proper output with case when statement?
body: <p>I want to output a table with the following columns:</p>
  
  <pre><code>ID|Start_date|Success|Fail
  1|01-01-2010|Yes|No
  2|02-01-2010|No|Yes
  
  My table structure is the following:
  
  Table 1: Start
  ID|Start_date
  
  Table 2: Success
  ID|Success_date 
  
  Table 3: Fail
  ID|Fail_date
  </code></pre>
  
  <p>Note that when there is a Start_id, it can either result in Success or Failure but not both at the same time. The ID is unique in each table.</p>
  
  <p>I wonder how we can just work with Table 1 and Table 2 to create the output format and then for the Failure column write a case statement which depend on Success (something like if Success=True, then Failure=No).</p>
  
  <p>How can I achieve this?</p>