SELECT * FROM TL_USER tu WHERE tu.TLNANME = 'longnht'
SELECT * FROM CM_DEPARTMENT cd WHERE cd.DEP_ID = (SELECT tu.DEP_ID FROM TL_USER tu WHERE tu.TLNANME = 'longnht')