联接结果给出重复的行-SQL Server

只需添加

group by

sum

SELECt I.InvoiceNumber, I.AmountPaid,sum(O.Amount) AmountFROM OrderInvoice OJOIN Invoice I ON O.InvoiceNumber = I.InvoiceNumber group by I.InvoiceNumber, I.AmountPaid

结果 ：

InvoiceNumber   AmountPaid  Amount123  10          10567  10          10