Produk untuk Harga Standar

select * from in_summary_monthly_amount A where doc_type_id = 311 and qty <> 0 and gl_amount = 0
    and not exists (select 1 from in_summary_monthly_cogs B
        where A.product_id = B.product_id
            and A.date_year_month = B.date_year_month
            and B.qty_total <> 0)