SELECT sap.problemid as attribute1,IF(DATA=(SELECT COUNT(*) FROM kit_details WHERE sapphire_req_id='CIMS\-BR08250008'),'Yes','No') as attribute6 FROM sd_servicereqmaster sm INNER JOIN sd_servicereq_additionalparams sap ON sap.problemid=sm.problemid WHERE sm.requestid='CIMS\-BR08250008' AND sap.fieldID=26
|
44
|
60,388
|
951
|
|
0.00
|