Case Statement

[sleezy]

This is my output

LoanReF TranType Credits Debits UnpaidFees
======= ======= ======= ====== ==========
GRF002612 DSCV 0.00 140.08 140.08
GRF002132 DSCH 0.00 480.12 480.12
THG006138 TRRF 0.00 926.54 926.54
JANFH00090 TRSR -795.84 0.00 -795.84
THG006103 PEIC -2388.42 2388.42 0.00
GRF002161 TRMR -3532.14 0.00 -3532.14


l would like to have all the loanrefs grouped together
ie

desired OutPut
==============

LoanReF TranType Credits Debits UnpaidFees
GRF002612 PEIC
GRF002612 TRMR
GRF002612 DSCV
GRF002612 DSCH

etc....
JANFH00090 PEIC
JANFH00090 TRMR
JANFH00090 DSCV
JANFH00090 DSCH

How can l tweak my script

SELECT
Transactions.*
,(Transactions.Credits + Transactions.Debits ) AS UnpaidFees
FROM
(
SELECT Dea151_Loan_Reference As LoanReF
,TRT151_Transaction_type AS TranType
,SUM
(CASE TranType WHEN 'C' THEN AMT151_Amount ELSE 0 END) AS Credits
,SUM(CASE TranType WHEN 'D' THEN AMT151_Amount ELSE 0 END) AS Debits
FROM (Select
* From Transactions
) AS Base_Data
GROUP BY
Dea151_Loan_Reference
,TRT151_Transaction_type) AS Transactions

[MAK]

SELECT
Transactions.*
,(Transactions.Credits + Transactions.Debits ) AS UnpaidFees
FROM
(
SELECT Dea151_Loan_Reference As LoanReF
,TRT151_Transaction_type AS TranType
,SUM
(CASE TranType WHEN 'C' THEN AMT151_Amount ELSE 0 END) AS Credits
,SUM(CASE TranType WHEN 'D' THEN AMT151_Amount ELSE 0 END) AS Debits
FROM (Select
* From Transactions
) AS Base_Data
GROUP BY
Dea151_Loan_Reference
,TRT151_Transaction_type) AS Transactions
order by LoanReF, TranType