select DISTINCT EDW.dbo.EDW_T_BD_AccountView.FNumber as A, EDW.dbo.EDW_T_BD_AccountView.FDisplayName_L2, EDW.dbo.EDW_T_BD_AccountView.FName_L2, T_KM_YSB.fnumber_l3, T_KM_YSB.SubjectLongName from EDW.dbo.EDW_T_BD_AccountView left join T_KM_YSB on EDW.dbo.EDW_T_BD_AccountView.FNumber=T_KM_YSB.FNumber where 1=1 ${if(len(FNumber)==0,"","and FNumber ='" + FNumber + "'")} 两个表有相同的字段，如何设置筛选条件 请回复SQL！！ |
1min目标场景问卷
立即参与
