Learn how Concerto can help you.
Results might look like this:
SELECT T.PartyId, SUM(T.Amount) as 'Amount' FROM [Transaction] T WHERE T.PaymentTypeId = 1 GROUP BY T.PartyId UNION SELECT Tr.PartyId, SUM(Tr.Amount) as 'Amount' FROM [Transaction] Tr JOIN [Transaction] T ON Tr.AdjustsTransactionId = T.TransactionId WHERE Tr.PaymentTypeId = 9 AND T.PaymentTypeId = 1 GROUP BY Tr.PartyId
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.