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