Return Return     Main page Main page      Update Update     Choice of period :  Day Day  Week Week  All All  Customized Customized


           (m/d/yy)     



Usages of UPDATE sd_servicereqmaster sm INNER JOIN sd_servicereq_additionalparams sap ON sm.problemid=sap.problemid INNER JOIN sd_servicereq_additionalparams sap1 ON sm.problemid=sap1.problemid INNER JOIN sd_servicereq_additionalparams sap2 ON sm.problemid=sap2.problemid INNER JOIN kit_details kd ON kd.Sapphire_Req_ID=sm.Requestid SET kd.sapphire_product_code=sap1.data ,kd.Sapphire_product_name=sap.data ,kd.branch_id=sap2.data WHERE requestid='CIMS\-BR07250033' AND sap.fieldid=24 AND sap1.fieldid=25 AND sap2.fieldid=136 AND kd.kit_number='81130044'

None
Powered by JavaMelody