怎么样对这个字段进行别名设置呢
SELECT (FType =
case FType
when 0 then '调拨单'
when 1 then '入库单'
when -60 then '盘亏单'
when -10 then '出库单'
else rtrim(FType)
end) as '单据类型'
FROM table
这样会报错的
SELECT (FType =
case FType
when 0 then '调拨单'
when 1 then '入库单'
when -60 then '盘亏单'
when -10 then '出库单'
else rtrim(FType)
end) as '单据类型'
FROM table
这样会报错的
SELECT 单据类型 = /*指定别名*/
case FType
when 0 then '调拨单'
when 1 then '入库单'
when -60 then '盘亏单'
when -10 then '出库单'
else rtrim(FType)
end
FROM table或者
SELECT
case FType
when 0 then '调拨单'
when 1 then '入库单'
when -60 then '盘亏单'
when -10 then '出库单'
else rtrim(FType)
end AS 单据类型 /*指定别名*/
FROM table