请教关于SQL视图的问题

lblclly 2015-05-31 10:42:36

CREATE view V_sk
as
select srbz,sflb,(case when sflb='AAAA' then 'AAAA' else sfxm end) as sfxm,skrq,jkfs,ysbh,ysxm,sksbh,sksm,zxksbh,zxksm,jzksbh,jzksm,sfdm,mc,dw,gg,jx,sl,
zyfs,zl,lsj,lsje,skyjzrq,ksjzrq,cfysje,cfssje,cfbz,fjf from y_sk left join
v_mzsfxm on y_sk.sfdm=v_mzsfxm.xmdm

在这个SQL语句建立的视图中，如何使sfxm为 null 的记录的sfxm字段的值换成sflb字段的值，多谢！

...全文

73 2 打赏收藏转发到动态举报

写回复

用AI写文章

2 条回复

切换为时间正序

请发表友善的回复…

发表回复

lblclly 2015-05-31

打赏
举报

引用 1 楼 ky_min 的回复:

CREATE    view V_sk
as
select srbz,sflb,(case when sflb='AAAA' then 'AAAA' WHEN sfxm IS NULL THEN sflb else sfxm end) as sfxm,skrq,jkfs,ysbh,ysxm,sksbh,sksm,zxksbh,zxksm,jzksbh,jzksm,sfdm,mc,dw,gg,jx,sl,
       zyfs,zl,lsj,lsje,skyjzrq,ksjzrq,cfysje,cfssje,cfbz,fjf from y_sk left join
      v_mzsfxm on y_sk.sfdm=v_mzsfxm.xmdm

加个分支即可

多谢了！

还在加载中灬 2015-05-31

打赏
举报

CREATE    view V_sk

as

select srbz,sflb,(case when sflb='AAAA' then 'AAAA' WHEN sfxm IS NULL THEN sflb else sfxm end) as sfxm,skrq,jkfs,ysbh,ysxm,sksbh,sksm,zxksbh,zxksm,jzksbh,jzksm,sfdm,mc,dw,gg,jx,sl,

       zyfs,zl,lsj,lsje,skyjzrq,ksjzrq,cfysje,cfssje,cfbz,fjf from y_sk left join

      v_mzsfxm on y_sk.sfdm=v_mzsfxm.xmdm

加个分支即可