SELECT A.TESTNO,
A.EXAM_SUBJECT,
A.TEXT,
A.TEST_NUM
A.EMP_NUM,
B.EMP_NAME
B.EMP_DEPT,
1.번-> (SELECT RQST_NO, MAX(ATCH_FLE_SEQ)
FROM SAMPLE_FILE
WHERE PGM_ID = 'SAMPLE_TEST'
GROUP BY RQST_NO)
FROM SAMPLE_TEST A
INNER JOIN
EMPLOYEE B
ON A.TEST_NUM = B.EMP_NUM
도움 좀 부탁드립니다.