17,086
社区成员
发帖
与我相关
我的任务
分享求助 ! 如下是SQLSERVER语法转换成ORACLE怎么写?：判断表中是否有数据， 再决定是否关联此表的写法
select x,xx,xxx
FROM T_BA_DRGs_MX a
'+(case when @table_KB_NUM =0 then '' else '
join Table_KB b on a.CH0A23 = b.Kname ' end) +
(case when @table_DRG_NUM =0 then '' else '
join Table_DRG c on a.DRGCode = c.Dname ' end) +'
WHERE a.bidate ='2018'
FROM T_BA_DRGs_MX a
'+(case when @table_KB_NUM =0 then '' else '
join Table_KB b on a.CH0A23 = b.Kname ' end) +
(case when @table_DRG_NUM =0 then '' else '
join Table_DRG c on a.DRGCode = c.Dname ' end) +'
WHERE a.bidate ='2018'
...全文
请发表友善的回复…
发表回复
nayi_224 2018-06-05
- 打赏
- 举报
直接外链接就好了嘛，连个空表又不碍事
