在线等待..sql 插入的时候删除重复

Question

NSERT INTO AccountPayable(SupplierName,BankAccount,Account,AccountPayables,UID)
SELECT
ientry.SupplierName,ientry.BankAccount,ientry.Account,SUM(InvoiceValue) AS AccountPayable,usr.PUserRName as UID
FROM InvoiceEntry ientry
INNER JOIN [User] usr
ON ientry.UID=usr.ID
WHERE 1=1
GROUP BY
ientry.SupplierName,ientry.Account,ientry.BankAccount,usr.PUserRName
插入之前我要判断表AccountPayable里面是否存在相同的,如果有我就不插入了