°è¿»ç¼±ÅÃ
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
ä¿ë°ø°í¼±ÅÃ
¹Ìµð¾îÆÀ ½ÅÀÔ»ç¿ø(°æ·ÂÆ÷ÇÔ) ¸ð
-
-