DỰ ÁN PHẦN MỀM QUẢN LÝ TÀI SẢN NGÂN HÀNG BẢN VIỆT

SELECT * FROM CM_GOODS WHERE GD_CODE ='DG.I.N.OE.0003.2021'

SELECT * FROM PL_TRADEDETAIL WHERE GOODS_ID ='GOO000000251691' AND PLAN_ID 

IN (SELECT PLAN_ID FROM PL_MASTER WHERE DEPT_ID IN (SELECT DEP_ID  FROM CM_DEPARTMENT WHERE DEP_CODE ='8990000') AND YEAR =2021)