1.9 HUYTN1 - CHECK TAI KHOAN CHIU CHI PHI.txt
| 1 |
DECLARE @OUT_ID VARCHAR(15) |
|---|---|
| 2 |
SET @OUT_ID =(SELECT * FROM MW_OUT WHERE OUT_CODE ='') -- DIEN MA CODE PHIEU XUAT |
| 3 |
SELECT A.*,C.MATERIAL_CODE FROM MW_OUT_DT A |
| 4 |
INNER JOIN MW_MAST_BAL B ON A.MAST_BAL_ID = B.MAST_BAL_ID |
| 5 |
INNER JOIN MW_MATERIAL C ON B.MATERIAL_ID = C.MATERIAL_ID |
| 6 |
WHERE A.OUT_ID =@OUT_ID |