insert into InterestReceive
select ContractNm,LoanBlankDate,Monthcapital,TotalInterest,RemainInterest,RemainPeriod,PeriodInterst,PeriodCapital,ExceedRate
from InterestList a where LoanBlankDate=GETDATE()
and not exists (select 1 from InterestReceive b
where a.ContractNm=b.ContractNm and a.LoanBlankDate=b.LoanBlankDate and a.TotalInterest=b.TotalInterest and a.RemainInterest=b.RemainInterest
and a.RemainPeriod=b.RemainInterest and a.PeriodInterst=b.PeriodInterst and a.PeriodCapital=b.PeriodCapital and a.ExceedRate=b.ExceedRate
)
我检查了好几遍了，为什么会出错呢？语法也没问题啊
消息 208，级别 16，状态 1，第 1 行
对象名 'InterestList' 无效。
------解决方案--------------------
from InterestList a where LoanBlankDate=GETDATE()
InterestList 已被你改为a了
------解决方案--------------------