在 查询分析器直接:create view xx as select case when xx=1 then '好' else '不好' end 别名 from 你的表
Create View yourViewName As SELECT CASE when D_C='D' then AMOUNT else NULL end as Jie,CASE when D_C='C' then AMOUNT else NULL end as Dai FROM LDG
双击你的视图,把Create View yourViewName As SELECT CASE when D_C='D' then AMOUNT else NULL end as Jie,CASE when D_C='C' then AMOUNT else NULL end as Dai FROM LDG拷贝进去,再点确认也可以.
as
select case when xx=1 then '好' else '不好' end 别名 from 你的表
As
SELECT CASE when D_C='D' then AMOUNT else NULL end as Jie,CASE when D_C='C' then AMOUNT else NULL end as Dai
FROM LDG
As
SELECT CASE when D_C='D' then AMOUNT else NULL end as Jie,CASE when D_C='C' then AMOUNT else NULL end as Dai
FROM LDG拷贝进去,再点确认也可以.