1SELECT COUNTDISTINCT IIQC_NUM FINISH FROM T_GDWMS_IQC I WHERE IIQC_SEND_DATE BETWEEN START_DATE AND END_DATE AND IIQC_STATE IN 2 3 AND IQC_MANAGER_AUDIT_RESULT IS NOT NUL

可以使用以下SQL语句将两个查询结果合并成一张表：

SELECT (SELECT COUNT(DISTINCT I.IQC_NUM) FROM T_GDWMS_IQC I WHERE I.IQC_SEND_DATE BETWEEN START_DATE AND END_DATE AND I.IQC_STATE IN ('2', '3') AND I.QC_MANAGER_AUDIT_RESULT IS NOT NULL) AS FINISH, NVL(COUNT(DISTINCT I.IQC_NUM), 0) AS SUCCESS FROM T_GDWMS_IQC I WHERE I.IQC_SEND_DATE BETWEEN START_DATE AND END_DATE AND I.IQC_STATE IN ('2', '3') AND I.QC_MANAGER_AUDIT_RESULT = '4'