SELECT   ID, dat
    FROM (SELECT   ins_id ID, end_date dat
          FROM F_INS
          UNION
          SELECT   occ_id ID, occ_date dat
          FROM F_OCC
          ORDER BY 2)
   WHERE ROWNUM <= 5
ORDER BY 2;

SELECT TOP 5 ID, dat
   FROM (
      SELECT   ins_id ID, end_date dat
         FROM F_INS
      UNION SELECT occ_id ID, occ_date dat
         FROM F_OCC) AS A
   ORDER BY 2

SELECT TOP 5 *
   FROM (
      SELECT
         F_OCCURRENCES.CAP_FACILITY_ID
,        F_OCCURRENCES.REG_SURR_ID as reg_surr_id
,        'N/A' as INPECTOR
,        'N/A' as COMPLIANCE_STATUS
,        'OCCURRENCE' as ACTIVITY
,        D_OCCURRENCE_OUTCOME.OUTCOME_ENG_DESC as OUTCOME
,        D_REGULATION.REG_ENGLISH_DESC AS REGULATION
,        F_OCCURRENCES.OCCURRENCE_DATE as theDATE
      FROM F_OCCURRENCES
      INNER JOIN D_OCCURRENCE_OUTCOME
         ON F_OCCURRENCES.OUTCOME_ID = D_OCCURRENCE_OUTCOME.OUTCOME_ID
      INNER JOIN D_REGULATION
         ON D_REGULATION.REG_SURR_ID = F_OCCURRENCES.REG_SURR_ID
      WHERE  cap_facility_id = '11518'
         and F_OCCURRENCES.REG_SURR_ID = '101' 
      UNION SELECT 
         F_INSPECTIONS.CAP_FACILITY_ID
,        F_INSPECTIONS.REG_SURR_ID as reg_surr_id
,        'NO DATA' as INSPECTOR
,        CASE Non_COMPLIANCE_IND
            WHEN 1 THEN 'Non-Compliant'
            WHEN 0 THEN 'Compliant'
         END as COMPLIANCE_STATUS
,        'INSPECTION' as ACTIVITY
,        DISP_ENGLISH_DESC as OUTCOME
,        D_REGULATION.REG_ENGLISH_DESC AS REGULATION
,        F_INSPECTIONS.START_DATE as theDATE
      FROM F_INSPECTIONS
      LEFT JOIN F_VIOLATIONS
         ON F_INSPECTIONS.INSPECTION_ID = F_VIOLATIONS.INSPECTION_ID
      LEFT JOIN D_DISPOSITION
         on D_DISPOSITION.VIOLATION_DISP_ID = F_VIOLATIONS.VIOLATION_DISP_ID
      LEFT JOIN D_REGULATION
         ON F_INSPECTIONS.REG_SURR_ID = D_REGULATION.REG_SURR_ID
      where  F_INSPECTIONS.REG_SURR_ID = '101'
         and F_INSPECTIONS.CAP_FACILITY_ID = '11518'
   ) AS z
   ORDER BY theDate desc