DỰ ÁN PHẦN MỀM QUẢN LÝ TÀI SẢN - NH BẢN VIỆT - GD3

SELECT * FROM SYS_GROUP_LIMIT WHERE GROUP_ID IN (SELECT GROUP_LIMIT_ID FROM SYS_HH_GROUP_LIMIT WHERE HH_ID IN (SELECT HANGHOA_ID FROM PL_REQUEST_DOC_DT WHERE REQ_ID ='PLRD00001160780'))

SELECT * FROM CM_HANGHOA WHERE HH_ID NOT IN (SELECT HH_ID FROM SYS_HH_GROUP_LIMIT)