SELECT CASE IsAuditing WHEN '0'THEN '未审核' WHEN '1'THEN '已审核'WHEN '2'THEN '拒绝 ' Else '错误' END AS IsAuditing, ( SELECT RealName FROM UserbaseInfo u WHERE u.UserID = em.UserID) AS RealName, ( SELECT Name FROM Equipments e WHERE em.EquipID = e.usefor+e.ID) AS EquipName,* from EquipMaintainApplication em;在SQL SERVER 下调试可以~
在ORACLE下报错ERROR 位于第 1 行:
ORA-00936: 缺少表达式
在ORACLE下报错ERROR 位于第 1 行:
ORA-00936: 缺少表达式
你应该在oracle板块问哑
decode(em.IsAuditing,
'0', '未审核' ,
'1', '已审核',
'2', '拒绝',
'错误'),
( SELECT RealName FROM UserbaseInfo u WHERE u.UserID = em.UserID) AS RealName,
( SELECT Name FROM Equipments e WHERE em.EquipID = e.usefor+e.ID) AS EquipName,
*
from EquipMaintainApplication em;
SELECT CASE IsAuditing WHEN '0'THEN '未审核' WHEN '1'THEN '已审核'WHEN '2'THEN '拒绝 ' Else '错误' END AS IsAuditing from EquipMaintainApplication em;可以通过~~