| CASE WHEN ((c_custname not like '%中信建投%') and custtype = '0') THEN '机构' WHEN ((c_custname not like '%招商证券%') and custtype = '0') THEN '机构' WHEN ((c_custname not like '%申万宏源%') and custtype = '0') THEN '机构' when ((c_custname like '%中信建投%') and custtype = '0') then '做市商' when ((c_custname like '%招商证券%') and custtype = '0') then '做市商' when ((c_custname like '%申万宏源%') and custtype = '0') then '做市商' else '个人' end as c_custtype 请大神帮我看看为什么我这个语句不起作用，只要custtype = 0的情况都是显示为机构，当c_custname符合后面条件的而且custtype = 0的时候值不为‘做市商’，这是为什么呢？ |
