SELECT * FROM gl_journal_trx_item A
INNER JOIN gl_journal_trx B ON A.journal_trx_id = B.journal_trx_id
WHERE SUBSTRING(B.doc_date, 1, 6)  = '201709' AND
      B.tenant_id = 10 AND
      B.ou_bu_id = 10
    AND A.coa_id IN (
        SELECT D.coa_id
        FROM in_summary_monthly_amount A
        INNER JOIN m_product B ON A.product_id = B.product_id
        INNER JOIN m_ctgr_product C ON B.ctgr_product_id = C.ctgr_product_id
        INNER JOIN m_group_product D ON D.group_product_id = C.group_product_id
        WHERE A.date_year_month  = '201709' AND
                  A.ou_bu_id = 10 AND
                  A.tenant_id = 10 AND
                  A.doc_type_id = 311
    )