select t1.CATALOG_TYPE, nvl(t2.REPORT_CNT,0) as REPORT_CNT, nvl(t3.PV,0) as PV, nvl(t3.UV,0) as UV, nvl(t3.F90_LINES,0) as F90_LINES, nvl(t3.F95_LINES,0) as F95_LINES, nvl(t3.F99_LINES,0) as F99_LINES, nvl(t4.REPORT_FAIL_TIMES,0) as REPORT_FAIL_TIMES, 9999 as REPORT_FULL_CNTfrom ods.ods_fr_system_relation