계열사선택
SELECT b.C_CODE, b.C_NAME_KOR FROM TB_RECRUIT_NOTICE a, TB_COMPANY b WHERE (a.C_COMPANY = b.C_CODE) AND (NOT a.C_FG_NOTICE_TYPE = 'C') AND (a.C_FG_DISPLAY = 'Y') AND (SYSDATE BETWEEN a.C_STARTDATE AND a.C_ENDDATE+1) GROUP BY b.C_CODE, b.C_NAME_KOR ORDER BY b.C_NAME_KOR
채용공고선택
미디어팀 신입사원(경력포함) 모
-
-
