계열사선택
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
모집분야선택
-
-
