34,874
社区成员
发帖
与我相关
我的任务
分享case...when...then...不能返回布尔值吗？
select A.registerDate as 登记日期,B.productType as 产品类型
from zcht_tz as A full outer join zcht_hk as B on A.htHao=B.htHao
where
(
case when B.sumLaiKuan<A.yuFuKuan
then true
else false
end
)
总是报语法错误！！各位给点意见。。。
from zcht_tz as A full outer join zcht_hk as B on A.htHao=B.htHao
where
(
case when B.sumLaiKuan<A.yuFuKuan
then true
else false
end
)
总是报语法错误！！各位给点意见。。。
...全文
请发表友善的回复…
发表回复
LoveSQL 2003-10-27
- 打赏
- 举报
--加上单引号就好了
select A.registerDate as 登记日期,B.productType as 产品类型
from zcht_tz as A full outer join zcht_hk as B on A.htHao=B.htHao
where
(
case when B.sumLaiKuan<A.yuFuKuan
then 'true'
else 'false'
end
)
select A.registerDate as 登记日期,B.productType as 产品类型
from zcht_tz as A full outer join zcht_hk as B on A.htHao=B.htHao
where
(
case when B.sumLaiKuan<A.yuFuKuan
then 'true'
else 'false'
end
)
pengdali 2003-10-27
- 打赏
- 举报
select A.registerDate as 登记日期,B.productType as 产品类型
from zcht_tz as A full outer join zcht_hk as B on A.htHao=B.htHao
where 1=
case when B.sumLaiKuan<A.yuFuKuan
then 1
else 0
end
from zcht_tz as A full outer join zcht_hk as B on A.htHao=B.htHao
where 1=
case when B.sumLaiKuan<A.yuFuKuan
then 1
else 0
end
