title: Oracle case statement with inner join
body: <p>Here is the SQL I have now:</p>
  
  <pre><code>SELECT i.busn_id,
         i.area_name,
         i.date,
         i.area_status,
         i.last_reason_id,
         last_reason.reason_description,
         i.first_reason_id,
         first_reason.reason_description
    FROM busn_info i
         JOIN busn_reason first_reason
           ON( i.first_reason_id = first_reason.reason_id )
         JOIN busn_reason last_reason
           ON( i.last_reason_id = last_reason.reason_id )
  </code></pre>
  
  <p>This SQL works great, but it only returns rows that have a LAST_REASON_ID and FIRST_REASON_ID. I want to include rows that may only have a LAST_REASON_ID or only a FIRST_REASON_ID but NOT rows that don't have either.</p>
  
  <p>I think there needs to be some kind of logical process built into it. Would a case stmt make sense? I've looked at examples on Stackoverflow and google, but I need a bit more guidance. </p>
  
  <p>Please let me know if I need to include anymore data to explain what I am trying to do.</p>