SELECT assetvalue,assetvalue FROM assetdetails WHERE itemdetailsid=142 AND (SELECT IF(DATA='RAW Card Location',1,0) FROM sd_servicereq_additionalparams WHERE problemid=786625 AND FieldID=132 ) UNION SELECT locationname,locationname FROM servicedesklocationmaster where locationname like '%19%' and (SELECT IF(DATA='RAW Card Location',0,1) FROM sd_servicereq_additionalparams WHERE problemid=786625 AND FieldID=132) |
3
|
3
|
0
|
|
0.00
|