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