title: Instead of no rows the query should return rows with null values in columns
body: <p>I have a query:</p>
  
  <pre><code>SELECT 
     PERSON_NAME 
  FROM 
     PERSON 
  WHERE 
     PERSON_ID = (SELECT ID FROM OTHER_TABLE WHERE PERSON_ID = 123)
  </code></pre>
  
  <p>Now, when a valid <code>person_id</code> is present in <code>OTHER_TABLE</code> the value of <code>PERSON_NAME</code> is returned.</p>
  
  <p>But when the <code>person_id</code> is not valid or is not present then it returns no rows. But instead I want it to return null for the person name.</p>
  
  <p>Can someone tell me how to do that?</p>
  
  <p>Thanks,
  Rajan</p>