haitao：
不要临时表/表变量，就用联合--不过删除可能也会有点问题，如果胡乱删除的话
[阅读: 811] 2004-09-01 03:09:26
select xmbh, xmmc, tzje, htbh, htmc, htje from (
select xmbh, 1 forder, xmmc, tzje, null htbh, null htmc,null htje from table1
union
select xmbh, 100 forder, null xmmc, null tzje, htbh, htmc, htje from table2
union
select a.xmbh, 200 forder, xmmc, null tzje, null htbh, '剩余' htmc, a.tzje-b.htje from table1 a
left join (select xmbh , sum(htje) fa from table2 group by xmbh) b on a.xmbh=b.xmbh
) a
order by xmbh,forder
| -ICP -IDC -ISP |