title: Return all Users, even those who don't fit my criteria
body: <p>I'm trying to return a full list of people, but only show data in the Document type column where the document type is 'Security Clearance Report'</p>
  
  <p>I'm quite new to SQL and trying to figure this stuff out. 
  The aim is so management can easily see who has got this doc type, but also who hasn't. </p>
  
  <pre><code>SELECT papf.person_id
       , (ppnf.first_name||' '||ppnf.last_name)                                    e_name
       , dor.document_name
       , dor_type.document_type
       , TO_CHAR(dor.creation_date, 'DD/MM/YYYY')                                  dor_issue_date
  FROM per_all_people_f                                         papf
       , per_person_names_f                                       ppnf
       , hr_document_types_vl                                     dor_type
       , hr_documents_of_record                                   dor
   WHERE SYSDATE BETWEEN papf.effective_start_date AND papf.effective_end_date
     AND papf.person_id                      = ppnf.person_id 
     AND SYSDATE BETWEEN ppnf.effective_start_date AND ppnf.effective_end_date
     AND ppnf.name_type                      = 'GLOBAL'
     AND papf.person_id                      = dor.person_id (+)
     AND dor_type.document_type_id           = dor.document_type_id
     AND dor_type.document_type = 'Security Clearance Report'
  ORDER BY e_name DESC
  </code></pre>