Menguap

WITH data_summary_monthly_amount_exclude AS (
SELECT  A.date_year_month, A.ou_bu_id, A.ou_branch_id, A.ou_sub_bu_id, A.product_id, SUM(A.qty) AS qty, SUM(A.gl_amount) AS gl_amount
FROM in_summary_monthly_amount A
GROUP BY date_year_month, ou_bu_id, ou_branch_id, ou_sub_bu_id, A.product_id
HAVING SUM(qty) = 0
AND SUM(gl_amount) <> 0
) SELECT * FROM data_summary_monthly_amount_exclude A
WHERE NOT EXISTS (
    SELECT 1 FROM in_summary_monthly_zero_qty_amount B
    WHERE A.date_year_month =  B.date_year_month
    AND A.ou_bu_id = B.ou_bu_id
    AND A.ou_branch_id = B.ou_branch_id
    AND A.ou_sub_bu_id = B.ou_sub_bu_id
    AND A.product_id = B.product_id
)
ORDER BY date_year_month, ou_bu_id, ou_branch_id, ou_sub_bu_id, product_id