Untitled

mail@pastecode.io avatar
unknown
plain_text
a year ago
542 B
1
Indexable
Never
write an python code to dynamically place an values in sql query like i have like eprm_join_cols_reim column in table in that i have values like this ppcr.product_component_id=tpcomp.product_component_id AND ppcr.op_id=tpcomp.op_id AND ppcr.bu_id=tpcomp.bu_id AND ppcr.catalog_id=tpcomp.catalog_id

now you should place above values in query like below
SELECT *
FROM tibtcare_ppm_st2.PPM_PRODUCT_COMPONENT_REF_MAP
WHERE (product_component_id, op_id, bu_id, catalog_id)

you should remove everything before = and after that everything before .