COM_CODE 테이블 TEAM | NAME 01 인천 02 서울 03 경기
==============================================================
MASTER 테이블 ORG_CODE | P_CODE | SAUPBU 1 C1 01 2 C2 02 3 C3 03
==============================================================
DRIVE 테이블 P_CODE | KM C1 50 C1 30 C2 50
==============================================================
JUYOU 테이블 P_CODE | LITER C2 30 C3 25 C3 25 C2 10
==============================================================
합계출력 SAUPBU | KM | LITER 인천 80 0 서울 50 40 경기 0 50
이렇게 출력하고 싶은데..않나오네요..ㅡㅜ;; ============================================================== 이게 제가 짠 쿼리문 입니다..
고수님들 도와 주세요..
더 간단한 방법이 있으면 점 알려 주시고요..
즐거운 하루 보내세요..꾸뻑
SELECT COM_CODE.NAME, SUM_DRIVE.SUM_KM, SUM_JUYOU.SUM_LITER
FROM MASTER,COM_CODE, ( SELECT SUM(DRIVE.KM) AS SUM_KM, MASTER.SAUPBU, DRIVE.P_CODE FROM DRIVE, MASTER WHERE DRIVE.P_CODE=MASTER.P_CODE GROUP BY MASTER.SAUPBU, DRIVE.P_CODE )SUM_DRIVE, ( SELECT SUM(JUYOU.LITER) AS SUM_LITER, MASTER.SAUPBU, JUYOU.P_CODE FROM JUYOU, MASTER WHERE JUYOU.P_CODE=MASTER.P_CODE GROUP BY MASTER.SAUPBU, JUYOU.P_CODE )SUM_JUYOU
WHERE COM_CODE.TEAM = MASTER.SAUPBU AND MASTER.P_CODE = SUM_DRIVE.P_CODE AND MASTER.P_CODE = SUM_JUYOU.P_CODE |