27,580
社区成员
发帖
与我相关
我的任务
分享
select number,c1,c2,c3 from t1 where number in ('xxx')
select number,d1,d2,d3 from t2 where number in ('xxx')
select number,max(c1)c1,max(c2)c2,max(c3)c3,max(d1)d1,max(d2)d2,max(d3)d3
from(
select number,c1,c2,c3,null as d1,null as d2,null as d3 from t1 where number in ('xxx')
union all
select number,null,null,null,d1,d2,d3 from t2 where number in ('xxx')
)t
group by number