如何实现两张表中的数据自动汇总？

ltcz125

设定现有： &nbsp; <br/>&nbsp; A表（BH为Key） &nbsp; <br/>&nbsp; BH &nbsp; &nbsp; &nbsp; &nbsp; Code &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Number &nbsp; <br/>&nbsp; 1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; a1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 20 &nbsp; <br/>&nbsp; 2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; b2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 3 &nbsp; <br/>&nbsp; &nbsp; <br/>&nbsp; B表（BH为Key） &nbsp; <br/>&nbsp; BH &nbsp; &nbsp; &nbsp; &nbsp; Code &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Number &nbsp; <br/>&nbsp; 1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; a1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 5 &nbsp; <br/>&nbsp; 2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; a2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 10 &nbsp; <br/>&nbsp; &nbsp; <br/><clk></clk>&nbsp; 怎样将B表的所有内容（事实不止几条）全部转移到A表的后边（A表原来的<nobr id="clickeyekey3" target="_blank" style="COLOR: #6600ff; BORDER-BOTTOM: #6600ff 1px dotted; BACKGROUND-COLOR: transparent; TEXT-DECORATION: underline;">保持</nobr>不变），即A表现在变为： &nbsp; <clk></clk><br/>&nbsp; A表 &nbsp; <br/>&nbsp; BH &nbsp; &nbsp; &nbsp; &nbsp; Code &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Number &nbsp; <br/>&nbsp; 1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; a1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 20 &nbsp; <br/>&nbsp; 2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; b2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 3 &nbsp; <br/>&nbsp; 3 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; a1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 5 &nbsp; <br/>&nbsp; 4 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; a2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 10

紫云金沙

<p>没太看懂楼主的意思，这个问题涉及到“汇总”么？简单的复制、粘贴不就解决问题了？</p><p></p>

ltcz125

复制、粘贴只适用于数据较少的表格，但如果数据较多的话，这样的两张表合并有点麻烦，请问给有其他的方法？

zfscnu

<p>只是要把BH 列的数字要延续A表的数字？？？</p><p></p><p></p>

紫云金沙

<p>lz还是上传个样表吧，说不清楚</p><p></p>