title: Need a blank value returned if no subquery results
body: <p>I am trying to look up the most recent value of <code>gorpaud_pin</code>, based on the date the record was added to the table. </p>
  
  <p>If there are no record, the entire query returns zero record.</p>
  
  <p>What i need instead is one record with a blank value for <code>gorpaud_pin</code>.</p>
  
  <pre><code>SELECT spriden_id, 
            spriden_last_name, 
            spriden_first_name, 
            gorpaud_pin 
       FROM spriden 
  LEFT JOIN gorpaud A 
         ON spriden_pidm = A.gorpaud_pidm 
        AND A.gorpaud_chg_ind = 'P' 
        AND A.gorpaud_pin IS NOT NULL 
      WHERE spriden_change_ind IS NULL 
        AND spriden_entity_ind = 'P' 
        AND to_char(A.gorpaud_activity_date, 'YYYY-MM-DD HH24:MI:SS') = 
          (SELECT max(to_char(B.gorpaud_activity_date, 'YYYY-MM-DD HH24:MI:SS')) 
             FROM gorpaud B 
            WHERE B.gorpaud_pidm = A.gorpaud_pidm
              AND B.gorpaud_chg_ind = 'P' 
              AND B.gorpaud_pin IS NOT NULL)
  </code></pre>