Oracle SQL - 오라클 sql - 여러 행을 하나로 결합

조인이있는 기본 피벗 쿼리는 여기에서 작동해야합니다.

SELECT
    t1.ID,
    t1.X,
    t1.Y,
    MAX(CASE WHEN t2.Category = 700 THEN t2.Entry END) Entry700,
    MAX(CASE WHEN t2.Category = 701 THEN t2.Entry END) Entry701,
    MAX(CASE WHEN t2.Category = 702 THEN t2.Entry END) Entry702,
    MAX(CASE WHEN t2.Category = 703 THEN t2.Entry END) Entry703,
    MAX(CASE WHEN t2.Category = 704 THEN t2.Entry END) Entry704
FROM T1 t1
INNER JOIN T2 t2
    ON t1.ProtocolID = t2.ProtocolID
GROUP BY
    t1.ID,
    t1.X,
    t1.Y;

다음과 같이 해보십시오 :

select t1.id, t1.x, t1.y, (select t2.entry from t2 where t1.id=t2.id and 
t2.category=700) as entry_700  from t1

작동해야합니다

SELECT *
FROM ( SELECT t1.id1,
           x,
           y,
           entry1,
           cat
    FROM t1,
         t2
    WHERE t1.protoid = t2.protoid )
        PIVOT ( MAX ( entry1 ) AS entry1
            FOR cat
            IN ( 700,701 )
        );