[Database]สอบถามปัญหาคำสั่ง SQL เกี่ยวกับการ query ข้อมูล ที่ไม่มีค่า และต้องการให้แสดงผล ออกมาเป็น 0 หรือแทนว่าไม่มีค่า

SELECT BUDGETTYPE.BUDTYPENAME BUDGETTYPE,
  OPERATION_ACTIVITY.OPERATION_ACTIVITY_NAME STATUS,
  PROJECTMASTER.PROJECTMASTERNAME  ||':'|| PROJECTS.PROJECTNAME PROJECTS,
  DEPARTMENTS.DEPTNAMEABB DEPTNAMEABB,
   (SELECT COST_TYPE_REPORT.NAME   FROM COST_TYPE_REPORT   WHERE COST_TYPE_REPORT.ID = 4   ) TYPE_,
  '' LABEL,
  ACTIVITYCOST.APPROVECOST COST_,
  PROJECT_STATEMENT.REMARK REMARK,
  PROJECT_STATEMENT.CREATE_DATE CREATE_DATE,
  1 ORDERBY,
  ,0 MONTHS
FROM PROJECT_STATEMENT
  INNER JOIN PROJECTS ON PROJECT_STATEMENT.PROJECTID = PROJECTS.PROJECTID
  INNER JOIN PROJECTMASTER ON PROJECTMASTER.PROJECTMASTERID = PROJECTS.PROJECTMASTERID
  INNER JOIN ACTIVITYS ON PROJECTS.PROJECTID = ACTIVITYS.PROJECTID
  INNER JOIN ACTIVITYCOST ON ACTIVITYS.ACTIVITYID = ACTIVITYCOST.ACTIVITYID
  INNER JOIN BUDGETTYPE ON PROJECT_STATEMENT.CATEGORY_BUDGET = BUDGETTYPE.BUDTYPEID
  INNER JOIN PROJECT_INFORM_STATUS ON PROJECTS.PROJECTID = PROJECT_INFORM_STATUS.PROJECTID
  INNER JOIN OPERATION_ACTIVITY ON PROJECT_INFORM_STATUS.ISSUE = OPERATION_ACTIVITY.OPERATION_ACTIVITY_ID
  INNER JOIN DEPARTMENTS ON DEPARTMENTS.DEPTID = PROJECTMASTER.DEPTID
WHERE ACTIVITYCOST.ISPRODUCT = 0 AND BUDGETTYPE.BUDTYPEID = 1