(case
when b."promotionid1"='' then ''
when b."promotionid2"='' then ''
when b."promotionid3"='' then ''
when b."promotionid4"='' then ''
when b."promotionid5"='' then ''
else ???
end
)
如果值不为空,怎么分别取到promotionid1......promotionid5的值???
when b."promotionid1"='' then ''
when b."promotionid2"='' then ''
when b."promotionid3"='' then ''
when b."promotionid4"='' then ''
when b."promotionid5"='' then ''
else ???
end
)
如果值不为空,怎么分别取到promotionid1......promotionid5的值???
when b."promotionid2"='' then ''
when b."promotionid3"='' then ''
when b."promotionid4"='' then ''
when b."promotionid5"='' then ''
这些字段都不会判断了是吗?
对 5 个都加case when 判断,或者直接使用 nvl(b.promitionid1,'') 这样也可以