Document #624
Lấy dữ liệu mua sắm giúp Chị Vân báo cáo năm
Start date:
11/15/2020
Due date:
% Done:
0%
Estimated time:
Description
SELECT B.REQ_CODE AS SỐ_PHIẾU_MUA_SẮM ,SUM AS SỐ_TIỀN_DỰ_KIẾN , SUM AS SỐ_TIỀN_THỰC_TẾ,ISNULL,0) - ISNULL,0) AS TIẾT_KIỆM FROM TR_REQUEST_DOC_DT A
LEFT JOIN TR_REQUEST_DOC B ON A.REQ_DOC_ID = B.REQ_ID
WHERE LEN (B.REQ_CODE) =15
GROUP BY B.REQ_CODE, A.REQ_DOC_ID
History
#1 Updated by Luc Tran Van over 4 years ago
- Status changed from New to Closed