아래의 결과값 처럼 수강생의 최근 수강한 강좌를 가져오고 싶습니다.

어떻게 쿼리를 짜야할지 모르겠습니다.

고수님들의 답변 부탁드립니다.

수강생테이블
SDX   NAME
----------------
1  김철수
2  홍길동

수강신청테이블
RDX       IDX            SDX
------------------------------------------
5             2                2
6            2                1
12          5                2
13          3                1

강좌테이블
IDX           CODE            YEAR          LECTURE_NAME                LECTURE_DATE
----------------------------------------------------------------------------------------------------------
2                  A1                2010                       국어                               2010-01-01
3                 A2                 2010                      영어                                2010-10-12
4                 C1                2009                     일본어                             2009-11-12
5                 B2                2010                     중국어                             2010-12-10

결과

SDX      NAME           CODE              YEAR               LECTURE_NAME             LECTURE_DATE
-----------------------------------------------------------------------------------------------------------------
1           김철수             A2                   2010                     영어                                 2010-10-12
2           홍길동            B2                    2010                   중국어                              2010-12-10