思路:Full join + coalesec()的使用
select
coalesce(t1.id,t2.id,t3.id) id,
t1.C1 C1,
t2.C2 C2,
t3.C3 C3
from t1
full join t2 on t1.id=t2.id
full join t3 on coalesce(t1.id,t2.id)=t3.id;
思路:Full join + coalesec()的使用
select
coalesce(t1.id,t2.id,t3.id) id,
t1.C1 C1,
t2.C2 C2,
t3.C3 C3
from t1
full join t2 on t1.id=t2.id
full join t3 on coalesce(t1.id,t2.id)=t3.id;