22,207
社区成员
发帖
与我相关
我的任务
分享
union all
或
full join
select a,b,c,0.00,'' from a
union all
select 0,0.00,c,d,e from b
C表:
[a](是int类型) [b](是decimal类型) [c](是varchar类型)[d](是float类型)[e](是varchar类型)
2 2222343.321 4378
6 6903.198 23348
7 9274.203 38920
8 10393.338 89761
tb1312 8879.1111 aaaa
fx3899 91273.1209 dddd
iuttt 23218.0928 ccee