EXPORT DOANH SỐ NCC - LẦN 3.txt
| 1 |
SELECT UPPER(A.SUP_NAME) AS NCC, UPPER(A.TAX_NO) AS TAX, UPPER(A.CONTACT_PERSON) AS NDD, UPPER(A.TEL) AS TEL, UPPER(A.EMAIL) AS EMAIL, SUM(B.TOTAL_AMT) AS DOANH_SO_2024 |
|---|---|
| 2 |
FROM CM_SUPPLIER A |
| 3 |
INNER JOIN TR_REQUEST_DOC_DT B ON A.SUP_ID = B.SUP_ID |
| 4 |
INNER JOIN TR_REQUEST_DOC C ON B.REQ_DOC_ID = C.REQ_ID |
| 5 |
WHERE C.PROCESS_ID ='APPROVE' AND YEAR(C.CREATE_DT) =2024 AND C.BRANCH_CREATE ='DV0001' |
| 6 |
GROUP BY A.SUP_NAME,A.TAX_NO,A.CONTACT_PERSON, A.TEL, A.EMAIL |