INSERT POLICY PRODUCT

INSERT INTO m_policy_product
        (user_role_id, sub_ctgr_product_id,
        active, active_datetime,
        create_datetime, create_user_id, update_datetime, update_user_id, version)
    SELECT A.user_role_id, B.sub_ctgr_product_id,
        'Y', '20170526010101',
        '20170526010101', -2, '20170526010101', -2, 0
    FROM t_user_role A, m_sub_ctgr_product B
    WHERE B.sub_ctgr_product_id NOT IN (
        SELECT C.sub_ctgr_product_id
        FROM m_policy_product C
        WHERE C.user_role_id = A.user_role_id
    )