Untitled

SELECT COUNT(*) FROM tibtcare_ppm_st2.TCARE_PPM_PRODUCT_AUD WHERE (product_id, op_id, bu_id, version) IN (SELECT tppa.reim.entity_id=tppa.product_id ,  tppa.reim.op_id=tppa.op_id ,  tppa.reim.bu_id=tppa.bu_id ,  tppa.reim.version=tppa.version FROM tibtcare_ppm_st2.release_entity_inst_map)


this is the secondary_query that iam getting after doing some modifications now i want do some more modifications like after IN operator in query you have replace those fields with text after = and . thet means if the column field is like tppa.reim.entity_id=tppa.product_id the you should replace everything with text after = and . that means the output will be only product_id