SELECT  A.REQ_CODE AS N'Số phiếu yêu cầu', A.REQ_REASON AS N'Nội dung',X.SUM_MS_TOTRINH AS N'Chủ trương', X.SUM_MS_THUCTE AS N'Thực tế', A.USER_DVMS AS N'Người thực hiện mua sắm', BR.BRANCH_NAME AS N'Đơn vị yêu cầu',
 DP.DEP_NAME AS N'Phòng ban yêu cầu', CASE WHEN A.PROCESS_ID ='APPROVE' THEN N'Hoàn tất' ELSE N'Đang thực hiện' END AS N'Tình trạng thực hiện'
 FROM  TR_REQUEST_DOC A
INNER JOIN
(
SELECT  REQ_DOC_ID,SUM(TOTAL_AMT) AS SUM_MS_THUCTE, SUM(TOTAL_AMT_ETM) AS SUM_MS_TOTRINH FROM TR_REQUEST_DOC_DT 
GROUP BY REQ_DOC_ID
) X ON A.REQ_ID = X.REQ_DOC_ID
INNER JOIN CM_BRANCH BR ON A.BRANCH_CREATE = BR.BRANCH_ID
LEFT JOIN CM_DEPARTMENT DP ON A.DEP_CREATE = DP.DEP_ID
ORDER BY BR.BRANCH_NAME