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