select,LABST,case WERKS when 'XZ01' then 'XZ01' end WERK1, case WERKS when 'XZA1' then 'XZA1' end WERK2 from MARD
select WARKS=case WARKS when 'XZ01' then '值1' when 'XZA1' then '值2' else '其他' end from MARD
是不是这样的: Select LABST,(CASE WERKS WHEN 'XZ01' THEN '值1' ELSE NULL END) AS 列2,(CASE WERKS WHEN 'XZA1' THEN '值2' ELSE NULL END) AS 列3 From MARD Where WARKS='XZ01'or WARKS='XZA1'
select WARKS=case WARKS when 'XZ01' then '值1' when 'XZA1' then '值2' else '其他' end
from MARD
Select LABST,(CASE WERKS WHEN 'XZ01' THEN '值1' ELSE NULL END) AS 列2,(CASE WERKS WHEN 'XZA1' THEN '值2' ELSE NULL END) AS 列3
From MARD
Where WARKS='XZ01'or WARKS='XZA1'
要求:WARKS='XZ01'和WARKS='XZA1'时分别得到LABST的值(即1个字段的查询结果为2个字段)
就是豌豆表达的意思,但为什么我的测试失败?提示CASE部分的“操作符丢失”。我在ACCESS中进行的测试。
FROM MARD