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

联接结果给出重复的行-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