SELECT *
FROM
(
SELECT M.*
FROM
TB_MASTER M, TB_JOB J 두 테이블 조인
WHERE
M.CD = J.CD AND
M.YEAR = J.YEAR AND
M.SEQ = J.SEQ
)A
WHERE A.CD = 'KOREA'
AND A.YEAR = '2005'
AND A.SEQ = '05'
---------------------------------------------
- 이것 보다는 아랫것이 더 나을듯한데요
---------------------------------------------
SELECT M.*, J......
FROM
TB_MASTER M, TB_JOB J 두 테이블 조인
WHERE M.CD = J.CD
AND M.YEAR = J.YEAR
AND M.SEQ = J.SEQ
AND M.CD = 'KOREA'
AND M.YEAR = '2005'
AND M.SEQ = '05'