create table A(id int,b int,c int,d int,f int)
insert into a values(1 ,22 ,13 ,16 ,12) 
insert into a values(2 ,31 ,14 ,12 ,14) 
create table B(id int,g int,h int)
insert into b values(1 ,3, 3) 
insert into b values(2 ,2, 5) 
insert into b values(3 ,8, 9)
go

select isnull(a.id,b.id) id,
       isnull(a.b,0) b,
       isnull(a.c,0) c,
       isnull(a.d,0) d,
       isnull(a.f,0) f,
       isnull(b.g,0) g,
       isnull(b.h,0) h
from a full join b on a.id = b.id

drop table a , b

/*
id          b           c           d           f           g           h           
----------- ----------- ----------- ----------- ----------- ----------- ----------- 
1           22          13          16          12          3           3
2           31          14          12          14          2           5
3           0           0           0           0           8           9

（所影响的行数为 3 行）
*/

------解决方案--------------------
SQL code

if object_id('[TA]') is not null drop table [TA]
create table [TA]([id] int,[b] int,[c] int,[d] int,[f] int)
insert [TA]
select 1,22,13,16,12 union all
select 2,31,14,12,14

if object_id('[TB]') is not null drop table [TB]
create table [TB]([id] int,[g] int,[h] int)
insert [TB]
select 1,3,3 union all
select 2,2,5 union all
select 3,8,9

select TB.id,
    b=isnull(b,0),
    c=isnull(c,0),
    d=isnull(d,0),
    f=isnull(f,0),
    g=isnull(g,0),
    h=isnull(h,0) 
from [TA] right join TB on TA.id=TB.id


/*
id          b           c           d           f           g           h
----------- ----------- ----------- ----------- ----------- ----------- -----------
1           22          13          16          12          3           3
2           31          14          12          14          2           5
3           0           0           0           0           8           9

(3 行受影响)

*/

drop table TA,TB

------解决方案--------------------

插入临时表再按上面的查不就一样了,插入临时表可能效率要好点
SQL code
SELECT * ,(co+co3) AS co4 INTO TA
FROM (
SELECT userid,uname,sendarc_num,(SELECT VALUE FROM AAA_sysconfig WHERE aid=729 AND groupid=5)AS a ,sendarc_num*(SELECT VALUE FROM AAA_sysconfig WHERE aid=729 AND groupid=5) AS co 
,arcpub_num,(SELECT VALUE FROM AAA_sysconfig WHERE aid=7230 AND groupid=5) AS co2,arcpub_num*(SELECT VALUE FROM AAA_sysconfig WHERE aid=7230 AND groupid=5) AS co3
FROM AAA_member
)tb1

SELECT * INTO TB 
FROM (
SELECT SUM(sign.point) AS POINT,COUNT(mb.mid) AS total, mb.*,user.userid,user.uname
FROM `AAA_sign_mb` mb
LEFT JOIN `AAA_sign_arc` SIGN ON sign.aid=mb.aid
LEFT JOIN `AAA_member` USER ON mb.mid=user.mid
GROUP BY mb.mid 
)tb2

------解决方案--------------------
SQL code
select
    b.id,
    b=isnull(b,0),
    c=isnull(c,0),
    d=isnull(d,0),
    f=isnull(f,0),
    g=isnull(g,0),
    h=isnull(h,0) 
from 
   (SELECT userid,uname,sendarc_num,(SELECT VALUE FROM AAA_sysconfig WHERE aid=729 AND groupid=5)AS a ,sendarc_num*(SELECT VALUE FROM AAA_sysconfig WHERE aid=729 AND groupid=5) AS co 
,arcpub_num,(SELECT VALUE FROM AAA_sysconfig WHERE aid