[Solved] SQL Statement two columns value return single value [closed]
[ad_1] Try this select id,[date],(case when refund = 1 then ‘R’ when voidstatus = 0 then ‘C’ when voidstatus = 1 then ‘V’ else ” end ) as [status],grossamt from trans 2 [ad_2] solved SQL Statement two columns value return single value [closed]