(SELECT CASE WHEN A.COUNTRY='CHN' THEN '' ELSE A.ADDRESS1 END as ADDRESS1 from Table A where .....)
应该是半角和全角的问题吧(SELECT CASE WHEN A.COUNTRY='CHN' THEN '' ELSE A.ADDRESS1 END from Table A where .....) as ADDRESS1
完整的太复杂,而且不是单纯的SQL,还用到了我这个开发工具的一些函数和meta-sql之类的东西
(SELECT CASE WHEN A.COUNTRY='CHN' THEN '' ELSE A.ADDRESS1 END from Table A where .....) as ADDRESS1子查询中少了列名--> (SELECT CASE WHEN A.COUNTRY='CHN' THEN '' ELSE A.ADDRESS1 END country from Table A where .....) as ADDRESS1
from Table A
where .....)
from Table A
where .....) as ADDRESS1
from Table A
where .....) as ADDRESS1子查询中少了列名-->
(SELECT CASE WHEN A.COUNTRY='CHN' THEN '' ELSE A.ADDRESS1 END country
from Table A
where .....) as ADDRESS1