본문 바로가기
개발

오라클 3개 테이블 조인해서 검색하기

by 6미리 2010. 8. 23.
SELECT  A.MID, B.CID, D.AID
FROM CS_MASTER_MAIN A, CS_CONTENTS_MAIN B, CS_FILE_MAIN C
WHERE A.MID = B.MID  AND B.CID = C.CID


SELECT 
CM.CID, -- CID(컨텐츠 메인)
'', -- CONTENTS CODE
MM.PID, -- PID
'', -- CONTENTS COUNT
'audio/mpeg', -- MIME_TYPE
'2', -- Encryption Method
'파일레벨의 FILE_PATH , source_path', -- NAS Input Path
'', -- NAS Output Path
CM.TITLE, -- TITLE
CM.DESCRIPTION, -- DESCRIPTION
'', -- COPYRIGHT
MA.BUBBING_ARTIST, -- PERFORMER
MA.WRITER, -- AUTHOR
'', -- GENRE
CM.CATEGORY_1, -- CLASSIFICATION
CM.KEYWORD, -- KEYWORD
CM.COUNTRY_ORIGIN, -- LOCATION
'', -- ALBUM
CM.CREATION_DATE , -- YEAR
'' -- RESULT
FROM CS_CONTENTS_MAIN CM, CS_MASTER_AUDBOOK MA, CS_MASTER_MAIN MM
WHERE CM.CID = MA.MID AND MA.MID = MM.PID

태그

, ,

댓글0