Oracle 多行 转一行 case when

create table TABLE_1
(
ID VARCHAR2(32 CHAR) not null,
PRODUCT_NAME VARCHAR2(32 CHAR)
)

create table TABLE_2
(
ID VARCHAR2(32 CHAR) not null,
T1_ID VARCHAR2(32 CHAR),
STATUS VARCHAR2(32 CHAR)
)

将如下结果集
PRODUCT_NAME STATUS

产品1 推荐

产品1 热销

产品2 推荐

产品2 热销

产品3

转换为

产品1 推荐 热销
产品2 推荐 热销
产品3


SELECT T1.PRODUCT_NAME,

max(CASE WHEN STATUS = '推荐' THEN STATUS END) AS VALUE1,

max(CASE WHEN STATUS = '热销' THEN STATUS END) AS VALUE2

FROM TABLE_1 T1 LEFT JOIN TABLE_2 T2 ON T1.ID = T2.T1_ID group by T1.PRODUCT_NAME