select
A.name,
isnull(A.A02,0)-isnull(B.B02,0)-isnull(C.C02,0)-isnull(D.D02,0)
from
A
left join
B
on
A.name=B.name
left join
C
on
A.name=C.name
left join
D
on
A.name=D.name
A.name,
isnull(A.A02,0)-isnull(B.B02,0)-isnull(C.C02,0)-isnull(D.D02,0)
from
A
left join
B
on
A.name=B.name
left join
C
on
A.name=C.name
left join
D
on
A.name=D.name
真是太感谢了!!!!!!!!!!!!11