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)