SELECT B.GD_CODE AS N'MÃ NGÂN SÁCH / CHI PHÍ',A.AMT_APP AS N'NGÂN SÁCH ĐƯỢC DUYỆT', 'A'+ BR.BRANCH_CODE AS N'ĐƠN VỊ','A' + D.DEP_CODE AS N' PHÒNG BAN', A.TRADE_ID, B.GD_ID, C.PLAN_ID FROM PL_TRADEDETAIL A
INNER JOIN CM_GOODS B ON A.GOODS_ID = B.GD_ID
INNER JOIN PL_MASTER C ON A.PLAN_ID = C.PLAN_ID
INNER JOIN CM_BRANCH BR ON C.BRANCH_ID = BR.BRANCH_ID
INNER JOIN CM_DEPARTMENT D ON C.DEPT_ID = D.DEP_ID
ORDER BY BR.BRANCH_CODE DESC, D.DEP_CODE DESC, AMT_APP DESC