I have a problem in an update, i need to update one coloum with a case condition that involves more than 1 case. The current sql statement i came up with goes like this.
set valueDKKTEMP = CASE exchange.rates when 0 then fms_data.value * 1 else exchange.rates * fms_data.value end
FROM HFO_Account RIGHT OUTER JOIN
FMS_DATA ON HFO_Account.CHILD = FMS_DATA.ACCOUNT LEFT OUTER JOIN
exchange ON HFO_Account.EXCHTYPE = exchange.TYPE AND FMS_DATA.CURRENCY = exchange._NAME_ AND
FMS_DATA.TIME = exchange.TIME AND FMS_DATA.ANALYSIS = exchange.ANALYSIS
but i also need to check for the currency being = dkk like this
set valueDKKTEMP CASE fms_data.currency WHEN 'dkk' THEN fms_data.value * 1