DECLARE @OUT_ID VARCHAR(15)
SET @OUT_ID =(SELECT * FROM MW_OUT WHERE OUT_CODE ='') -- DIEN MA CODE PHIEU XUAT
SELECT  A.*,C.MATERIAL_CODE FROM MW_OUT_DT A
INNER JOIN MW_MAST_BAL B ON A.MAST_BAL_ID = B.MAST_BAL_ID
INNER JOIN MW_MATERIAL C ON B.MATERIAL_ID = C.MATERIAL_ID
WHERE A.OUT_ID =@OUT_ID