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