pivot在Oracle的多个表上

Question

我有以下三个表

表1mf_tab

<表类>id>生产商tbody><<tr>12341google12342苹果

一个常用的透视方法是条件聚合:

select
id,
max(case when seq = 1 then t1.mfr end) as mfr1,
max(case when seq = 2 then t1.mfr end) as mfr2,
max(case when seq = 1 then t2.flag end) as flag1,
max(case when seq = 2 then t2.flag end) as flag2,
max(case when seq = 1 then t3.pn end) as pn1,
max(case when seq = 2 then t3.pn end) as pn2
from t1
join t2 using (id, seq)
join t3 using (id, seq)
group by id
order by id;