临时表:tbex_Large_Temp
实表:tbex_Large
--删除tbex_Large_Temp表中与tbex_Large表中重复的数据
delete tbex_Large_Temp
from tbex_Large a
where tbex_Large_Temp.Batch_Id = a.Batch_Id
and tbex_Large_Temp.Cust_Acct = a.Cust_Acct
Batch_Id、Cust_Acct 为联合主键
临时表:tbex_Large_Temp
实表:tbex_Large
--删除tbex_Large_Temp表中与tbex_Large表中重复的数据
delete tbex_Large_Temp
from tbex_Large a
where tbex_Large_Temp.Batch_Id = a.Batch_Id
and tbex_Large_Temp.Cust_Acct = a.Cust_Acct
Batch_Id、Cust_Acct 为联合主键