WIe SUM in der Datenbanktabelle richtig benutzen?

adnanche · 26. Februar 2019, 14:16

Wie nutze ich hier SUM richtig, um die beide Werte der "TotalAmount" zusammengefasst (addiert) als ein Ergebnis darzustellen?

Select Sum (dbo.File_Extern_Accounts.Amount) As TotalAmount, dbo.Key_AccountingRecords.Name_DE
From dbo.File_Extern_Accounts
Inner Join dbo.Key_AccountingRecords On dbo.File_Extern_Accounts.AccountingRecordID = dbo.Key_AccountingRecords.ID
Inner Join dbo.File_Events On dbo.File_Events.ID = dbo.File_Extern_Accounts.FileEventID
Where (dbo.File_Events.EventType=1
OR dbo.File_Events.EventType=520)
AND FileID = 5970
Group By dbo.Key_AccountingRecords.Name_DE

petaod · 26. Februar 2019, 14:23

Select Sum (dbo.File_Extern_Accounts.Amount) As TotalAmount
From dbo.File_Extern_Accounts
Inner Join dbo.Key_AccountingRecords On dbo.File_Extern_Accounts.AccountingRecordID = dbo.Key_AccountingRecords.ID
Inner Join dbo.File_Events On dbo.File_Events.ID = dbo.File_Extern_Accounts.FileEventID
Where (dbo.File_Events.EventType=1
OR dbo.File_Events.EventType=520)
AND FileID = 5970