请教大家一个sql语句问题
请教大家一个SQL问题:select a.no,
(case when a.CaseCode = "01" then "Y" else 0 end),
(case when a.CaseCode = "02" then "Y" else 0 end),
(case when a.CaseCode = "03" then "Y" else 0 end)
from check a
where a.date between "20091001" and "20101001"
and a.cancel <> "1"
报“800: Corresponding data types must be compatible in CASE expression or DECODE”的错误,请问是什么原因啊??
先谢谢了!!! 是informix吗?0 加上引号改成字符型试试 else 0 --> else '0'
因为你前面是字符型,后面的0也要是字符型'0' 不错。要字符型。这么大意。
页:
[1]