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'
uj5u.com熱心網友回復:
直接外鏈接就好了嘛,連個空表又不礙事轉載請註明出處,本文鏈接:https://www.uj5u.com/shujuku/66588.html
標籤:開發
上一篇:請教rowNum 和 left join 寫一起時出現的問題
下一篇:Mysql架構
