select DISTINCTEDW.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.SubjectLongNamefrom EDW.dbo.EDW_T_BD_AccountView left join T_KM_YSBon EDW.dbo.EDW_T_BD_AccountView.FNumber=T_KM_YSB.FNumberwhere 1=1${if(len(FNumber)==0,"","and FNumber ='" + FNumber + "'")}两个表有相同的字段,如何设置筛选条件 请回复SQL!!