当前位置: 代码迷 >> Sql Server >> 高手看段代码,异常
  详细解决方案

高手看段代码,异常

热度:14   发布时间:2016-04-27 11:13:46.0
高手看段代码,错误
select SRR_ID,SRR_Type,SRR_Source,SRR_Creator,SRR_CDate from SB_Repair_Record inner join 
 (case when SRR_Type='103' then SB_Repair_Declare on SFD_ID else SB_Repair_Plan on SRP_ID end) = SRR_Source

------解决方案--------------------
select SRR_ID,SRR_Type,SRR_Source,SRR_Creator,SRR_CDate 
from SB_Repair_Record 
inner join SB_Repair_Declare on SB_Repair_Declare.SFD_ID = SB_Repair_Record.SRR_Source
Where SB_Repair_Record.SRR_Type='103'
union all
select SRR_ID,SRR_Type,SRR_Source,SRR_Creator,SRR_CDate 
from SB_Repair_Record 
inner join SB_Repair_Plan on SB_Repair_Plan.SFD_ID = SB_Repair_Record.SRR_Source
Where SB_Repair_Record.SRR_Type <> '103'
  相关解决方案