22,206
社区成员
发帖
与我相关
我的任务
分享
select m.a,m.b,m.c,n.a1,n.a2,n.a3
from table1 m full join table2 n
on m.pk1 = n.pk1
select a,b,c,a1,b1,c1 from t1 a inner join t2 b on a.pk1=b.pk1
select a,b,c,a1=null,b1=null,c1=null from t1
union
select null,null,null,a1,b1,c1 from t2
select * from table1 full join table2 on 1<>1