Select
  Contract.Name As Rekeningnaam,
  Contract.IBan As Rekening,
  Transactions.InterestDate As Rentedatum,
  Transactions.DebitAmount As "Bedrag Bij",
  Transactions.CreditAmount As "Bedrag Af",
  Account.Number As Relatierekening,
  Relation.Name As Relatienaam,
  Transactions.BookDate As Boekdatum,
  PaymentType.Code As Betalingscode,
  PaymentType.Description As Betalingsomschrijving,
  Transactions.Remark As Opmerking,
  Category.Name As Hoofdrubriek,
  Category1.Name As Rubriek,
  Transactions.Description As Omschrijving
From
  Transactions Inner Join
  Contract On Transactions.ContractId = Contract.Id Left Join
  Relation On Transactions.RelationId = Relation.Id Left Join
  Account On Relation.AccountId = Account.Id Left Join
  PaymentType On Transactions.PaymentTypeId = PaymentType.Id Left Join
  Category On Transactions.MainCategoryId = Category.Id Left Join
  Category Category1 On Transactions.CategoryId = Category1.Id
Order By
  Boekdatum,
  Rekeningnaam
